COF-C03 - Performance Optimization, Querying, and Transformation - Section 4.2

Explain the Snowflake caches including the result cache, the metadata cache, and the virtual warehouse local disk cache, and when each applies.

Explain the three caches that speed up queries: the result cache that returns an identical query's result for up to 24 hours without compute, the metadata cache used by the cloud services layer to answer some queries without a warehouse, and the local disk (warehouse) cache that holds recently read micro-partitions while a warehouse runs. Recognise what invalidates each cache.

Examworthy is not affiliated with or endorsed by Snowflake. Original, blueprint-aligned practice material only.