SnowPro Core Certification — Question 1013

Which statistics can be used to identify queries that have inefficient pruning? (Choose two.)

Answer options

• A. Bytes scanned
• B. Bytes written to result
• C. Partitions scanned
• D. Partitions total
• E. Percentage scanned from cache

Correct answer: C, D

Explanation

The correct answers are C and D because 'Partitions scanned' indicates how many partitions were accessed during the query, while 'Partitions total' shows the overall number of partitions available. If a large number of partitions are scanned relative to the total, it suggests that pruning is inefficient. The other options do not directly relate to the effectiveness of partition pruning.