What data is stored in the Snowflake storage layer? (Choose two.)
What data is stored in the Snowflake storage layer? (Choose two.)
The Snowflake storage layer is designed to store data in a highly optimized and compressed format. Micro-partitions, which are a fundamental part of Snowflake's architecture, store the actual data in columnar format, making querying efficient. Query history is part of the metadata that helps Snowflake keep track of executed queries and is also stored in the storage layer. Meanwhile, persisted query results refer to cached results and are stored in the cloud service layer, not the storage layer.
B. Micro-partitions C. Query history (also stored in the data layer of SNOWFLAKE.USAGE_SCHEMA)
https://docs.snowflake.com/en/user-guide/querying-persisted-results.html Persisted here means cached, so Persisted Query Results is the query result cache which is in the cloud service layer, not storage layer
Service Layer: Which accepts SQL requests from users, coordinates queries, managing transactions and results. Logically, this can be assumed to hold the result cache – a cached copy of the results of every query executed. https://community.snowflake.com/s/article/Caching-in-the-Snowflake-Cloud-Data-Platform D cannot be right because the services layer stores cache, not the the storage layer
B & D. https://www.snowflake.com/data-cloud-glossary/data-storage/
D talks about result cache and E all query results go to result cache. Result cache is CSL so B and C
B. Micro-partitions C. Query history
B and C are correct
Correct
should be BC. cannot be E as non-materialised view results are not stored.
Verified