Snowflake COF-R02 Question Answer
Which of the following describes how clustering keys work in Snowflake?
Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
Clustering keys sort the designated columns over time, without blocking DML operations
Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns
Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time
TESTED 02 Aug 2025
Copyright © 2014-2025 ACE4Sure. All Rights Reserved