
Explanation:
The question asks for two statements that describe features of Snowflake's data caching. Based on the community discussion and Snowflake documentation:
Other options are incorrect:
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.
Ultimate access to all questions.
No comments yet.
Which of the following statements describe features of Snowflake's data caching? (Choose two.)
A
When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
B
When the data cache is full, the least-recently used data will be cleared to make room.
C
A user can only access their own queries from the query result cache.
D
A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
E
The RESULT_SCAN table function can access and filter the contents of the query result cache.