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

Latest SnowPro Core Practice Questions with 427 Q&As

Updated Study Material | Instant Download | Detailed Answers and Explanations

Subscribe
Notify of
guest
0 Comments