Answer-first summary for fast verification
Answer: The columns most actively used in the select filters.
The correct answer is D because Snowflake's official documentation and best practices recommend selecting clustering keys based on columns that are most actively used in selective filters. This approach maximizes the performance benefits of clustering by reducing the amount of data scanned during query execution. The community discussion strongly supports this with 100% consensus on answer D, and detailed comments reference Snowflake's guidance that clustering columns used in selective filters (like date ranges) provides the greatest optimization. Options A, B, and C are less suitable: A (columns in SELECT clause) doesn't impact pruning efficiency, while B and C (high cardinality/many values) alone don't ensure effective clustering unless those columns are used in filters.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
When deciding to cluster a table in Snowflake, what should be selected as the clustering key?
A
The columns that are queried in the select clause.
B
The columns with very high cardinality.
C
The columns with many different values.
D
The columns most actively used in the select filters.