What feature can be used to reorganize a very large table on one or more columns?

The correct answer is B. Clustering keys. Clustering keys (option B) are the Snowflake feature used to reorganize large tables. When defined on one or more columns, Snowflake's Automatic Clustering service periodically rewrites micro-partitions so that rows with similar clustering key values are stored together. This…

Performance Management

Question

Options

AMicro-partitions
BClustering keys
CKey partitions
DClustered partitions

How the community answered

(23 responses)

A
4% (1)
B
91% (21)
C
4% (1)

Explanation

Clustering keys (option B) are the Snowflake feature used to reorganize large tables. When defined on one or more columns, Snowflake's Automatic Clustering service periodically rewrites micro-partitions so that rows with similar clustering key values are stored together. This reduces the number of micro-partitions scanned during queries that filter on those columns (partition pruning), dramatically improving performance for very large tables. Option A (micro-partitions) are Snowflake's underlying storage units - they exist automatically and are not a configuration feature you apply. Options C and D (Key partitions, Clustered partitions) are not valid Snowflake terminology.

Topics

#Clustering keys#Table optimization#Data organization#Performance management

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice