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

Question

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.

• A
  6% (4)
• B
  89% (57)
• C
  3% (2)
• D
  2% (1)

Explanation

B is correct: Snowflake's local disk cache (data cache) on a virtual warehouse uses an LRU (Least Recently Used) eviction policy - when the cache fills up, the least recently accessed data is evicted first. E is correct: RESULT_SCAN is a Snowflake table function that lets you query the result set of a previous query by its query ID, effectively filtering the query result cache. - A is wrong: the data cache is lost when a warehouse is suspended. C is wrong: any user running the same query (with the same role and context) can benefit from the result cache. D is wrong: USE_METADATA_CACHE is not a valid Snowflake parameter.

No community discussion yet for this question.