Each Snowflake micro‑partition stores column‑level statistical metadata that the query optimizer uses for efficient pruning and planning.
The two relevant metadata types are:
Number of distinct values (NDV) per column – An approximate count of unique values in each column of the micro‑partition, used for cardinality estimation and pruning decisions.
Minimum and maximum values for each column – The low and high data range stored for every column, enabling “min–max” pruning so Snowflake only reads partitions that can satisfy a given filter predicate.
1. D is not correct, because the question is about metadata stored for each micro-partition. But, in D it is about the full table.
2. Right answer is A and E, because there, it is not mentioned any full table.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Billhardy
1Â week, 5Â days ago37ceea2
3Â months agoMultiCloudIronMan
3Â months, 2Â weeks agoMohit78jain
3Â months, 3Â weeks ago