SnowPro Core Certification — Question 203

Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

Answer options

• A. Bytes sent over network
• B. Percentage scanned from cache
• C. Partitions total
• D. Bytes spilled to local storage
• E. Partitions scanned

Correct answer: C, E

Explanation

The correct answers are C and E because the total number of partitions and the number of partitions scanned directly indicate how much data is being processed and whether unnecessary partitions are being eliminated. The other options do not specifically relate to pruning efficiency; for example, bytes sent over the network and bytes spilled to local storage measure data transfer and storage efficiency rather than pruning effectiveness.