Snowflake
COF-R02 · Question #85
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
The correct answer is D. Data may be colocated by the cluster key within the micro-partitions to improve pruning. See the full explanation below for the reasoning.
Question
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
Options
- 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
- 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
How the community answered
(44 responses)- A5% (2)
- B16% (7)
- C7% (3)
- D73% (32)
Community Discussion
No community discussion yet for this question.