Which statistics on a Query Profile reflect the efficiency of the query pruning? (Select TWO).

The correct answer is A. Partitions scanned D. Bytes scanned. Snowflake uses micro-partition pruning to skip irrelevant data during query execution. In the Query Profile, 'Partitions scanned' shows how many micro-partitions were actually read - a lower number relative to the total indicates effective pruning. 'Bytes scanned' shows how…

Performance Management

Question

Options

APartitions scanned
BPartitions total
CBytes spilled
DBytes scanned
EBytes written

How the community answered

(15 responses)

C
7% (1)
D
93% (14)

Explanation

Snowflake uses micro-partition pruning to skip irrelevant data during query execution. In the Query Profile, 'Partitions scanned' shows how many micro-partitions were actually read - a lower number relative to the total indicates effective pruning. 'Bytes scanned' shows how much raw data was read after pruning; fewer bytes means the optimizer successfully eliminated unnecessary data. Together, these two metrics reveal how well Snowflake's pruning reduced the query's I/O footprint. 'Bytes spilled' relates to memory overflow, and 'Bytes written' relates to DML output - neither reflects pruning effectiveness.

Topics

#Query Profile#Query Pruning#Performance Optimization#Micro-partitions

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice