Exam SnowPro Core topic 1 question 349 discussion

B. Micro-partitions C. Query history (also stored in the data layer of SNOWFLAKE.USAGE_SCHEMA)

QUERY_HISTORY view This Account Usage view can be used to query Snowflake query history by various dimensions (time range, session, user, warehouse, etc.) within the last 365 days (1 year).

I think is B and C - in the documentation when it uses the word persisted it talks about 24h period of retention, which is the result set retention time living in the service cloud layer. So i don't think D is correct. https://docs.snowflake.com/en/user-guide/querying-persisted-results

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

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