
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.
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.