While creating a clustering key, what is the recommendation for maximum number of columns that you can include as part of the key?

While creating a clustering key, what is the recommendation for maximum number of columns that you can include as part of the key?
A . Unlimited
B. 3 to 4
C. Not more than 16
D. 32

View Answer

Answer: B

Explanation:

A single clustering key can contain one or more columns or expressions. For most tables, Snowflake

recommends a maximum of 3 or 4 columns (or expressions) per key. Adding more than 3-4 columns

tends to increase costs more than benefits.

https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html#strategies-for-selecting-clustering-

keys