
Explanation:
The correct answers are C (Partitions total) and E (Partitions scanned) because efficient pruning in Snowflake is determined by comparing these two statistics. When pruning is efficient, the number of partitions scanned (E) should be significantly smaller than the total number of partitions (C), indicating that only relevant data partitions were accessed. This relationship is confirmed by the community discussion, where multiple users with high upvotes reference Snowflake documentation on inefficient pruning and explain that comparing these metrics shows pruning effectiveness. Other options like bytes sent over network (A), percentage scanned from cache (B), and bytes spilled to local storage (D) relate to different performance aspects but do not directly measure partition pruning efficiency.
Which query profile statistics indicate efficient pruning is occurring? (Select two.)
A
Bytes sent over network
B
Percentage scanned from cache
C
Partitions total
D
Bytes spilled to local storage
E
Partitions scanned
No comments yet.