SnowPro Core Certification — Question 244

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

Answer options

• A. Micro-partitions
• B. Clustering keys
• C. Key partitions
• D. Clustered partitions

Correct answer: B

Explanation

The correct answer is B, Clustering keys, as they are specifically designed to optimize the storage and retrieval of data in large tables by reorganizing it based on specified columns. The other options, while related to data organization, do not provide the same functionality for reorganizing tables in this manner.