SnowPro Core Certification — Question 358

Which statement describes pruning?

Answer options

• A. The filtering or disregarding of micro-partitions that are not needed to return a query.
• B. The return of micro-partitions values that overlap with each other to reduce a query's runtime.
• C. A service that is handled by the Snowflake Cloud Services layer to optimize caching.
• D. The ability to allow the result of a query to be accessed as if it were a table.

Correct answer: A

Explanation

The correct answer, A, accurately describes pruning as the process of filtering out unnecessary micro-partitions for a query. Option B incorrectly suggests that overlapping micro-partitions are returned, which does not align with the concept of pruning. Options C and D pertain to different functionalities within Snowflake and do not accurately define pruning.