Answer: Range of values, Distinct values

Snowflake stores metadata for rows within micro-partitions to optimize query performance and data management. The correct answers are A (Range of values) and B (Distinct values). Snowflake tracks the range of values (min/max) for each column in a micro-partition, which allows it to quickly eliminate micro-partitions that don't contain relevant data during query execution through pruning. It also stores the number of distinct values, which helps with query optimization and cardinality estimation. Options C, D, and E are incorrect: Snowflake does not store index values (it uses micro-partition metadata instead of traditional indexes), it does not specifically store sorted values (though data may be clustered), and while it tracks null presence, null values are not a primary metadata type stored for rows in this context. The community discussion shows 100% consensus on AB with upvoted comments confirming this is correct.

Author: LeetQuiz Editorial Team