An architect is mapping which Snowflake cache lives in which layer and what each one actually stores. Which pairings correctly match a cache to its location and contents? Select THREE.
- AQuery result cache: held in the cloud services layer and stores the materialised result set of a previously executed query for reuse within its retention window. Correct
- BFail-safe cache: held in the storage layer and keeps a fast-access copy of recently dropped tables so identical queries against them return without compute.
- CMetadata cache: held in the cloud services layer and stores object and micro-partition statistics such as row counts and per-column min and max values. Correct
- DWarehouse local disk cache: held on a virtual warehouse's compute nodes and stores micro-partition data read during scans, and is lost when the warehouse suspends. Correct
Why A is correct: The result cache sits in the cloud services layer and keeps finished result sets, so an identical query on unchanged data returns those rows without compute.
Why B is wrong: This is a fabricated cache; Fail-safe is a seven-day recovery period for permanent data, not a query cache, so it serves no repeated SELECT and the pairing is invalid.
Why C is correct: The metadata cache is maintained in the services layer and holds statistics used for pruning and for resolving some aggregate lookups, not raw data or full results.
Why D is correct: The local disk cache lives on warehouse compute SSD, caches scanned micro-partition data, and is cleared on suspend, matching its location and contents exactly.