Answer: When the data cache is full, the least-recently used data will be cleared to make room., The RESULT_SCAN table function can access and filter the contents of the query result cache.

The question asks for two statements that describe features of Snowflake's data caching. Based on the community discussion and Snowflake documentation: - Option B is correct: Snowflake's data cache uses a least-recently used (LRU) eviction policy, where the least-recently used data is cleared when the cache is full. This is a standard caching mechanism and is well-documented. - Option E is correct: The RESULT_SCAN table function can access and filter the contents of the query result cache. This function allows users to retrieve and manipulate cached query results, including applying filters and other clauses not in the original query. Other options are incorrect: - Option A is wrong because the data cache is cleared when a virtual warehouse is suspended, not saved on remote storage. - Option C is incorrect because the query result cache is shared; any user can access cached results if they run the same query and have the necessary permissions, though RESULT_SCAN access is user-specific. - Option D is incorrect because the metadata cache is used by default; no explicit setting is required. The consensus in the community discussion strongly supports BE, with 73% of users selecting it and high upvotes on explanations confirming B and E. While some users initially selected CE due to confusion about RESULT_SCAN access, clarified comments note that C is not correct for general query result cache usage, reinforcing BE as the optimal answer.

Author: LeetQuiz Editorial Team