SnowflakeSnowflake
COF-C02 · Question #218
COF-C02 Question #218: Real Exam Question with Answer & Explanation
The correct answer is A: The filtering or disregarding of micro-partitions that are not needed to return a query.. Pruning in Snowflake refers to the process of filtering or disregarding micro-partitions that are not needed to satisfy the conditions of a query. This optimization technique helps reduce the amount of data scanned, thereby improving query performance.
Performance Concepts
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.
Explanation
Pruning in Snowflake refers to the process of filtering or disregarding micro-partitions that are not needed to satisfy the conditions of a query. This optimization technique helps reduce the amount of data scanned, thereby improving query performance.
Topics
#Pruning#Micro-partitions#Query Optimization#Performance
Community Discussion
No community discussion yet for this question.