What feature can be used to reorganize a very large table on one or more columns?

What feature can be used to reorganize a very large table on one or more columns?
A . Micro-partitions
B . Clustering keys
C . Key partitions
D . Clustered partitions

View Answer

Answer: B

Explanation:

Clustering keys in Snowflake are used to reorganize large tables based on one or more columns. This feature optimizes the arrangement of data within micro-partitions to improve query performance, especially for large tables where efficient data retrieval is crucial.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html