What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).

The correct answer is C. A column with very high cardinality D. A column that is most actively used in selective filters. Snowflake recommends clustering keys on columns with high cardinality (many distinct values) because they enable more precise pruning of micro-partitions - each partition covers a narrower value range. Columns used in selective filters (WHERE clause predicates) are also ideal…

Performance Management

Question

Options

AA VARIANT column
BA column with very low cardinality
CA column with very high cardinality
DA column that is most actively used in selective filters
EA column that is most actively used in join predicates

How the community answered

(37 responses)

B
3% (1)
C
95% (35)
E
3% (1)

Explanation

Snowflake recommends clustering keys on columns with high cardinality (many distinct values) because they enable more precise pruning of micro-partitions - each partition covers a narrower value range. Columns used in selective filters (WHERE clause predicates) are also ideal because clustering physically co-locates rows matching common filter values, minimizing partitions scanned. Low-cardinality columns provide little pruning benefit. VARIANT columns are semi-structured and not suitable as clustering keys. Join predicate columns (E) are a lower priority compared to filter columns.

Topics

#Clustering#Performance Optimization#Micro-partitions#Query Performance

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice