Snowflake
COF-R02 · Question #85
COF-R02 Question #85: Real Exam Question with Answer & Explanation
Sign in or unlock COF-R02 to reveal the answer and full explanation for question #85. The question stem and answer options stay visible for context.
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
Unlock COF-R02 to see the answer
You've previewed enough free COF-R02 questions. Unlock COF-R02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.