COF-C02 · Question #672
Which Snowflake layer is always leveraged when accessing a query from the result cache?
The correct answer is D. Cloud Services. Snowflake's architecture has three layers: Storage, Compute (virtual warehouses), and Cloud Services. The query result cache is managed and stored entirely within the Cloud Services layer. When a cached result is served, it bypasses the Compute layer entirely - no virtual…
Question
Which Snowflake layer is always leveraged when accessing a query from the result cache?
Options
- AMetadata
- BData Storage
- CCompute
- DCloud Services
How the community answered
(42 responses)- A5% (2)
- B2% (1)
- C2% (1)
- D90% (38)
Explanation
Snowflake's architecture has three layers: Storage, Compute (virtual warehouses), and Cloud Services. The query result cache is managed and stored entirely within the Cloud Services layer. When a cached result is served, it bypasses the Compute layer entirely - no virtual warehouse is needed. This is why result cache hits incur no compute cost. The Cloud Services layer handles query optimization, metadata management, and result caching, making it the layer always involved in cache retrieval.
Topics
Community Discussion
No community discussion yet for this question.