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

The correct answer is B. Micro-partitions D. Persisted query results. 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…

Storage and Data Protection

Question

Options

ASnowflake parameters
BMicro-partitions
CQuery history
DPersisted query results
EStandard and secure view results

How the community answered

(36 responses)

A
3% (1)
B
94% (34)
C
3% (1)

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

Topics

#Snowflake architecture#Storage layer#Micro-partitions#Persisted query results

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice