COF-C02 Question #117: Real Exam Question with Answer & Explanation

Question

Assume there is a table consisting of five micro-partitions with values ranging from A to Z. Which diagram indicates a well-clustered table? A. B. C. D.

Options

• ADiagram showing 5 micro-partitions with overlapping and gapped ranges (e.g., DE, JK, NO, ST, Z) within A-Z.
• BDiagram showing 5 micro-partitions, where each micro-partition spans the entire range from A to Z.
• CDiagram showing 5 micro-partitions with distinct, sequential, and non-overlapping ranges covering A-Z (e.g., A-F, G-L, M-R, S-X, Y-Z).
• DDiagram showing 5 micro-partitions with significant overlaps in ranges (e.g., A-F, DE-JK, JK-NO, NO-ST, ST-Z) within A-Z.

Explanation

A well-clustered table in Snowflake means that the data is organized in such a way that related data points are stored close to each other within the micro-partitions. This optimizes query performance by reducing the amount of scanned data. The diagram indicated by option C shows a well-clustered table, as it likely represents a more evenly distributed range of values across the micro-partitions.

No community discussion yet for this question.