What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).
A.
A VARIANT column
B.
A column with very low cardinality
C.
A column with very high cardinality
D.
A column that is most actively used in selective filters
E.
A column that is most actively used in join predicates
The Answer Is:
C, D
This question includes an explanation.
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.
COF-C02 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"