SnowPro Core Certification — Question 653

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

Answer options

• 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

Correct answer: D, E

Explanation

Snowflake recommends using columns that are frequently utilized in selective filters or join predicates as clustering keys because these columns help optimize query performance by reducing the amount of data scanned. Columns with low cardinality may not provide sufficient data distribution for effective clustering, while high cardinality columns may not be as beneficial for clustering as those actively used in filtering or joins.