What data is stored in the Snowflake storage layer? (Select TWO).

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

View Answer

Answer: B, D

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.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

Key Concepts & Architecture | Snowflake Documentation2