SnowPro Core Certification — Question 1300

Which of the following statements describe features of Snowflake data caching? (Choose two.)

Answer options

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

Correct answer: B, E

Explanation

Option B is correct because when the data cache is full, Snowflake removes the least-recently used data to free up space. Option E is also correct as the RESULT_SCAN function allows users to access and filter data from the query result cache. The other options are incorrect due to misunderstandings of how the cache works or incorrect requirements for accessing it.