SnowPro Core Certification — Question 740
What metadata does Snowflake store for rows in micro-partitions? (Choose two.)
Answer options
- A. Range of values
- B. Distinct values
- C. Index values
- D. Sorted values
- E. Null values
Correct answer: A, B
Explanation
The correct answers are A and B because Snowflake stores the range of values and distinct values for each micro-partition to optimize query performance. Options C, D, and E are incorrect as Snowflake does not utilize index values, sorted values, or null value metadata in the same way for micro-partitions.