Answer: Partitions scanned, Partitions total

The question asks for two statistics that can be used to observe the effects of query pruning. Query pruning in Snowflake involves skipping irrelevant micro-partitions during query execution to improve performance. The community discussion shows strong consensus for AB (Partitions scanned and Partitions total), with the highest upvoted comment (3 upvotes) explicitly stating AB is correct and referencing Snowflake documentation. Comparing 'Partitions scanned' (actual partitions accessed) against 'Partitions total' (total available partitions) directly shows pruning efficiency - a low ratio indicates effective pruning. While 'Bytes scanned' (option C) is mentioned in one comment, it has fewer upvotes (2) and the overall community consensus favors AB. Options D (Bytes read from result) and E (Bytes written) are unrelated to query pruning effects.

Author: LeetQuiz Editorial Team