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.
ArunRav
3Â weeks, 5Â days agoBillhardy
3Â months, 4Â weeks ago37ceea2
6Â months, 2Â weeks agoMultiCloudIronMan
7Â months, 1Â week agoMohit78jain
7Â months, 1Â week ago