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

Question

Martin Stoyanov · Accepted Answer

When the data cache is full, the least-recently used data will be cleared to make room.

Martin Stoyanov · Accepted Answer

A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

Martin Stoyanov · Answer

When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

Martin Stoyanov · Answer

A user can only access their own queries from the query result cache.

Martin Stoyanov · Answer

The RESULT_SCAN table function can access and filter the contents of the query result cache.

List of questions