Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
When a CLUSTER BY clause is defined for a Snowflake table, what is the immediate effect on the physical data in the table?
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
