Snowflake
COF-R02 · Question #277
Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
The correct answer is B. Percentage scanned from cache E. Partitions scanned. See the full explanation below for the reasoning.
Question
Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
Options
- ABytes sent over network
- BPercentage scanned from cache
- CPartitions total
- DBytes spilled to local storage
- EPartitions scanned
How the community answered
(29 responses)- A7% (2)
- B76% (22)
- C14% (4)
- D3% (1)
Community Discussion
No community discussion yet for this question.