Answer: The range of values for each of the columns in the micro-partition, The number of distinct values for each column in the micro-partition

According to Snowflake's official documentation on micro-partitions, Snowflake stores metadata about all rows in a micro-partition including: (1) The range of values for each of the columns in the micro-partition, and (2) The number of distinct values for each column in the micro-partition. These metadata elements enable Snowflake's query optimization and pruning capabilities. Option D corresponds to the range of values per column, and option E corresponds to the number of distinct values per column. The community discussion shows 100% consensus on DE, with multiple users citing the official documentation. Options A, B, and C are incorrect: A refers to total row count which is not the specific metadata stored, B refers to partition ranges rather than column ranges, and C refers to row-level ranges rather than column-level ranges.

Author: LeetQuiz Editorial Team