Snowflake
COF-R02 · Question #324
Which statement describes pruning?
The correct answer is A. The filtering or disregarding of micro-partitions that are not needed to return a query. See the full explanation below for the reasoning.
Question
Which statement describes pruning?
Options
- AThe filtering or disregarding of micro-partitions that are not needed to return a query.
- BThe return of micro-partitions values that overlap with each other to reduce a query's runtime.
- CA service that is handled by the Snowflake Cloud Services layer to optimize caching.
- DThe ability to allow the result of a query to be accessed as if it were a table.
How the community answered
(53 responses)- A77% (41)
- B6% (3)
- C4% (2)
- D13% (7)
Community Discussion
No community discussion yet for this question.