Snowflake
COF-R02 · Question #204
COF-R02 Question #204: Real Exam Question with Answer & Explanation
Sign in or unlock COF-R02 to reveal the answer and full explanation for question #204. The question stem and answer options stay visible for context.
Question
Which of the following statements describe features of Snowflake data caching? (Choose two.)
Options
- AWhen a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
- BWhen the data cache is full, the least-recently used data will be cleared to make room.
- CA user can only access their own queries from the query result cache.
- DA user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
- EThe RESULT_SCAN table function can access and filter the contents of the query result cache.
Unlock COF-R02 to see the answer
You've previewed enough free COF-R02 questions. Unlock COF-R02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.