nerdexam
Snowflake

COF-R02 · Question #204

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

The correct answer is B. When the data cache is full, the least-recently used data will be cleared to make room. D. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries. See the full explanation below for the reasoning.

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.

How the community answered

(49 responses)
  • A
    2% (1)
  • B
    80% (39)
  • C
    6% (3)
  • E
    12% (6)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice