Which of the following describes how clustering keys work in Snowflake?
Which of the following describes how clustering keys work in Snowflake?
Clustering keys in Snowflake sort the designated columns over time without blocking DML (Data Manipulation Language) operations. This means that while data in a table can be re-organized based on the clustering keys to improve query performance, such reorganization does not interrupt or block the normal insertions, deletions, or updates being performed on the table.
Correct Answer B
correct answer is B
B. https://docs.snowflake.com/en/user-guide/tables-auto-reclustering Non-blocking DML Automatic Clustering is transparent and does not block DML statements issued against tables while they are being reclustered.
B. Clustering keys sort the designated columns over time, without blocking DML operations.
correct
B https://docs.snowflake.com/en/user-guide/tables-clustering-keys#what-is-a-clustering-key
correct answer is B