SnowPro Core Certification — Question 793

How does Snowflake improve the performance of queries that are designed to filter out a significant amount of data?

Answer options

• A. The use of indexing
• B. The use of pruning
• C. The use of TableScan
• D. By increasing the number of partitions scanned

Correct answer: B

Explanation

The correct answer is B, as pruning allows Snowflake to skip irrelevant data blocks based on the query's filters, significantly boosting performance. Options A and C are not applicable since Snowflake does not rely on traditional indexing or TableScan for performance improvement. Option D would actually slow down performance by increasing the amount of data that is scanned.