SnowPro Core Certification — Question 1028

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

Answer options

• A. Partitions scanned
• B. Partitions total
• C. Bytes scanned
• D. Bytes spilled
• E. Bytes written

Correct answer: A, B

Explanation

The correct answers are A and B because 'Partitions scanned' shows how many partitions were actually accessed during the query, while 'Partitions total' indicates the overall number of partitions available. Options C, D, and E do not specifically measure the efficiency of query pruning, as they focus on data volume rather than partitioning.