Which cache type is used to cache data output from SQL queries?

Question

Options

• AMetadata cache
• BResult cache
• CRemote cache
• DLocal file cache

• A
  6% (1)
• B
  89% (16)
• D
  6% (1)

Explanation

Snowflake has three distinct cache layers. The Result Cache (B) stores the output of every SQL query for 24 hours in the cloud services layer. If an identical query is re-executed and the underlying data has not changed, Snowflake returns the cached result instantly with no warehouse usage. The Metadata Cache (A) stores table statistics like row counts and min/max values, used to answer certain queries without touching data. The Local Disk Cache (D), also called the warehouse cache, stores columnar micro-partition data that has been read into SSD/memory on a virtual warehouse node. There is no 'Remote Cache' as a named Snowflake cache type (C).

No community discussion yet for this question.