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 COF-C02 Practice Questions with 254 Q&As
Updated Study Material | Instant Download | Detailed Answers and Explanations
Subscribe
Login
0 Comments