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.
The Answer Is:
A
This question includes an explanation.
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
SnowPro-Core PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 60% Discount on All Products,
Use Coupon: "8w52ceb345"