SnowPro Core Certification — Question 306

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

Answer options

• A. Data is hashed by the cluster key to facilitate fast searches for common data values
• B. Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned
• C. Smaller micro-partitions are created for common data values to allow for more parallelism
• D. Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Correct answer: D

Explanation

The correct answer, D, is accurate because using a CLUSTER BY clause allows data to be organized by the cluster key within micro-partitions, which enhances pruning efficiency during queries. Options A, B, and C describe different aspects of data management but do not specifically address the concept of colocating data by the cluster key within micro-partitions.