SnowPro Advanced: Data Engineer — Question 112

A Data Engineer is trying to improve the performance of a long-running query by clustering the base table.

What information from the output of the CLUSTERING_INFORMATION system function will verify that the clustering improved query performance?

Answer options

• A. The average number of overlapping micro-partitions in the table is high.
• B. The total number of constant micro-partitions in the table is high.
• C. The average overlap depth of each micro-partition in the table is high.
• D. The total number of constant micro-partitions in the table is low.

Correct answer: B

Explanation

The correct answer is B because a high number of constant micro-partitions indicates improved data organization, which leads to better query performance. Options A and C suggest issues with overlapping partitions, while D indicates a low number of constant partitions, which would not support enhanced performance.