Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Which of the following describes how clustering keys function in Snowflake?
A
Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
B
Clustering keys sort the designated columns over time, without blocking DML operations.
C
Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns.
D
Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time.