SnowPro Core Certification — Question 829

The effects of query pruning can be observed by evaluating which statistics? (Choose two.)

Answer options

• A. Partitions scanned
• B. Partitions total
• C. Bytes scanned
• D. Bytes read from result
• E. Bytes written

Correct answer: A, B

Explanation

The correct answers, A and B, reflect the number of partitions that were actually scanned versus the total number of partitions available, which directly indicates the effectiveness of query pruning. The other options, such as C, D, and E, focus on data volume rather than the partitioning aspect, thus are not relevant for evaluating query pruning effects.