Exam4Training

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

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.

Latest DEA-C01 Dumps Valid Version with 100 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version