Answer-first summary for fast verification
Answer: The filtering or disregarding of micro-partitions that are not needed to return a query.
Pruning in Snowflake refers to the optimization technique where the query engine filters out micro-partitions that are not needed to satisfy a query, thereby reducing the amount of data scanned and improving query performance. Option A correctly defines this concept. Option B is incorrect as it describes overlapping micro-partitions, which is not related to pruning. Option C is incorrect as pruning is handled by the query processing layer, not specifically the Cloud Services layer for caching. Option D describes a materialized view or result set access, not pruning.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is the definition of pruning in the context of Snowflake?
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.
No comments yet.