Answer: Partitions total, Partitions scanned

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.

Author: LeetQuiz Editorial Team