Putting a higher cardinality column before a lower cardinality column will generally reduce the effectiveness of clustering on the later column

Putting a higher cardinality column before a lower cardinality column will generally reduce the effectiveness of clustering on the later column
A . TRUE
B. FALSE

View Answer

Answer: A

Explanation

If you are defining a multi-column clustering key for a table, the order in which the columns are specified in the CLUSTER BY clause is important. As a general rule, Snowflake recommends ordering the columns from lowest cardinality to highest cardinality. Putting a higher cardinality column before a lower cardinality column will generally reduce the effectiveness of clustering on the latter column.