Snowflake SnowPro Core
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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