Answer: Partitions scanned, Partitions total

The question asks about statistics that reflect query pruning efficiency in Snowflake's Query Profile. Query pruning refers to the optimization technique where Snowflake eliminates unnecessary partitions from scanning, improving performance. According to the community discussion and Snowflake documentation referenced, the 'Pruning' section specifically contains 'Partitions scanned' (number of partitions actually scanned) and 'Partitions total' (total partitions in the table). These two metrics directly indicate pruning effectiveness: a lower ratio of scanned partitions to total partitions means better pruning. Options C, D, and E (Bytes scanned, Bytes spilled, Bytes written) relate to data volume and spilling operations but do not specifically measure partition elimination efficiency, making them less suitable for assessing pruning.

Author: LeetQuiz Editorial Team