Answer-first summary for fast verification
Answer: To enable efficient pruning based on query filters
The correct answer is B because collecting statistics in Snowflake enables efficient pruning based on query filters. Statistics provide metadata about the data in micro-partitions (such as min/max values), allowing the query optimizer to skip irrelevant micro-partitions during query execution, which significantly improves performance. Option A is incorrect because statistics are not primarily for identifying data storage order correlations. Option C is incorrect because statistics collection doesn't reduce the number of micro-partitions - micro-partitions are created automatically during data loading. Option D is incorrect because the purpose is to read only relevant data, not all data in a table. The community discussion strongly supports B with 100% consensus and upvoted comments explaining how statistics help with partition pruning.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is the purpose of collecting statistics on data in Snowflake?
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
No comments yet.