What data is stored in the Snowflake storage layer? (Select TWO).
A.
Snowflake parameters
B.
Micro-partitions
C.
Query history
D.
Persisted query results
E.
Standard and secure view results
The Answer Is:
B, D
This question includes an explanation.
Explanation:
The Snowflake storage layer is responsible for storing data in an optimized, compressed, columnar format. This includes micro-partitions, which are the fundamental storage units that contain the actual data stored in Snowflake. Additionally, persisted query results, which are the results of queries that have been materialized and stored for future use, are also kept within this layer. This design allows for efficient data retrieval and management within the Snowflake architecture1.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide