Snowflake
COF-R02 · Question #147
Which of the following describes how clustering keys work in Snowflake?
The correct answer is B. Clustering keys sort the designated columns over time, without blocking DML operations. See the full explanation below for the reasoning.
Question
Which of the following describes how clustering keys work in Snowflake?
Options
- AClustering keys update the micro-partitions in place with a full sort, and impact the DML
- BClustering keys sort the designated columns over time, without blocking DML operations
- CClustering keys create a distributed, parallel data structure of pointers to a table's rows and
- DClustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at
How the community answered
(38 responses)- A3% (1)
- B84% (32)
- C3% (1)
- D11% (4)
Community Discussion
No community discussion yet for this question.