Which of the following describes how clustering keys work in Snowflake?

Which of the following describes how clustering keys work 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

Answer: B

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments