COF-C02 · Question #258
COF-C02 Question #258: Real Exam Question with Answer & Explanation
The correct answer is C: A column with very high cardinality. Snowflake recommends using columns with very high cardinality and those that are most actively used in selective filters as clustering keys. High cardinality columns have a wide range of unique values, which helps in evenly distributing the data across micro-partitions. Columns u
Question
What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).
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
Explanation
Snowflake recommends using columns with very high cardinality and those that are most actively used in selective filters as clustering keys. High cardinality columns have a wide range of unique values, which helps in evenly distributing the data across micro-partitions. Columns used in selective filters help in pruning the number of micro-partitions to scan, thus improving query performance. References: Based on general database optimization principles.
Topics
Community Discussion
No community discussion yet for this question.