SnowPro Core Certification — Question 341

Which result shows efficient pruning?

Answer options

• A. Partitions scanned is greater than partitions total.
• B. Partitions scanned is less than partitions total.
• C. Partitions scanned is equal to the partitions total.
• D. Partitions scanned is greater than or equal to the partitions total.

Correct answer: B

Explanation

The correct answer is B because efficient pruning should result in scanning fewer partitions than the total available, indicating that unnecessary partitions were excluded. Options A, C, and D suggest that either too many partitions were scanned or all were scanned, which does not reflect effective pruning.