DEA-C02: SnowPro Advanced — Data EngineerDemo

Question

How can a clustering key definition be used to lower the number of distinct values in a high-cardinality column?

A Define the key as an expression on the column.
B Define the key by using the CONCAT function on the column.
C Define the key by using the SCAN function on the column.
D Define the key by using the TRIM function on the column.

Explanation

For a high-cardinality column, define the clustering key as an order-preserving expression on that column, such as converting a timestamp to a date. The expression reduces the number of distinct key values while retaining useful pruning behavior.

Learn more

Clustering Keys & Clustered Tables

DEA-C02: SnowPro Advanced — Data EngineerDemo

AstroTutor

Notes

Readiness

QuestionQ5

Community Discussion