What metadata does Snowflake store for rows in micro-partitions? (Select TWO).

The correct answer is A. Range of values B. Distinct values. Snowflake automatically collects and stores metadata for each micro-partition (compressed columnar storage units of 50–500 MB of uncompressed data). The metadata stored per column per micro-partition includes: (A) the range of values - the minimum and maximum values in that…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

ARange of values
BDistinct values
CIndex values
DSorted values
ENull values

How the community answered

(43 responses)

A
95% (41)
C
2% (1)
D
2% (1)

Explanation

Snowflake automatically collects and stores metadata for each micro-partition (compressed columnar storage units of 50–500 MB of uncompressed data). The metadata stored per column per micro-partition includes: (A) the range of values - the minimum and maximum values in that column - which enables partition pruning during query execution, and (B) the number of distinct values, used by the query optimizer for cardinality estimation. This metadata allows Snowflake to skip entire micro-partitions that cannot possibly satisfy a query's filter predicates, drastically reducing I/O without requiring user-defined indexes.

Topics

#Micro-partitions#Data Storage#Query Optimization#Metadata

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice