SnowPro Core Certification — Question 764

What technique does Snowflake use to limit the number of micro-partitions scanned by each query?

Answer options

• A. B-tree
• B. Indexing
• C. Map reduce
• D. Pruning

Correct answer: D

Explanation

The correct answer is D, Pruning, which allows Snowflake to skip over unnecessary micro-partitions based on query filters, thus optimizing performance. The other options, such as B-tree and Indexing, are not utilized by Snowflake in this context, and Map reduce is not relevant to how Snowflake handles data access.