SnowPro Core Certification — Question 837

Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?

Answer options

• A. Caching
• B. Cluster depth
• C. Query pruning
• D. Retrieval optimization

Correct answer: C

Explanation

Query pruning is the correct answer as it specifically allows Snowflake to skip over unnecessary micro-partitions, thereby enhancing query performance. The other options, like Caching and Retrieval optimization, do not directly control the scanning of micro-partitions, while Cluster depth refers to the organization of the data rather than the query execution process.