SnowPro Core Certification — Question 889

What is the purpose of collecting statistics on data in Snowflake?

Answer options

• A. To identify data storage order correlations
• B. To enable efficient pruning based on query filters
• C. To reduce the total number of micro-partitions in a table
• D. To optimize query performance by reading all data in a table

Correct answer: B

Explanation

The correct answer is B because collecting statistics allows Snowflake to efficiently prune data that does not match query filters, thereby improving performance. Options A and C are incorrect as they do not directly relate to the main purpose of statistics collection, while D is wrong because reading all data would not optimize performance.