SnowPro Core Certification — Question 337

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

Answer options

• 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.

Correct answer: D

Explanation

The correct answer is D because the cluster key should focus on the columns that are frequently used in filters to enhance query performance by minimizing the amount of data scanned. Options A, B, and C do not necessarily prioritize the most impactful columns for filtering, which is crucial for effective clustering.