Snowflake Exam COF-C02 Topic 3 Question 60 Discussion

Actual exam question for Snowflake's COF-C02 exam

Question #: 60
Topic #: 3

[All COF-C02 Questions]

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

AData is hashed by the cluster key to facilitate fast searches for common data values

BLarger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

CSmaller micro-partitions are created for common data values to allow for more parallelism

DData may be colocated by the cluster key within the micro-partitions to improve pruning performance

Show Suggested Answer

Suggested Answer: D

When aCLUSTER BYclause is added to a Snowflake table, it specifies one or more columns to organize the data within the table's micro-partitions. This clustering aims to colocate data with similar values in the same or adjacent micro-partitions. By doing so, it enhances the efficiency of query pruning, where the Snowflake query optimizer can skip over irrelevant micro-partitions that do not contain the data relevant to the query, thereby improving performance.

References:

Snowflake Documentation on Clustering Keys & Clustered Tables1.

Community discussions on how source data's ordering affects a table with a cluster key

by Merilyn at Aug 19, 2025, 12:48 AM

Limited Time Offer

25%

Off

Get Premium COF-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Vincenza

2 days ago

I think the answer is A) Data is hashed by the cluster key to facilitate fast searches for common data values.

upvoted 0 times

...