SnowPro Core Certification — Question 735

What metadata does Snowflake store concerning all rows stored in a micro-partition? (Choose two.)

Answer options

• A. A count of the number of total values in the micro-partition
• B. The range of values for each partition in the micro-partition
• C. The range of values for each of the rows in the micro-partition
• D. The range of values for each of the columns in the micro-partition
• E. The number of distinct values for each column in the micro-partition

Correct answer: D, E

Explanation

The correct answers, D and E, represent the metadata that Snowflake tracks for each column within a micro-partition, including the range and distinct values. Options A, B, and C are incorrect as they do not reflect the specific metadata Snowflake stores about rows and columns within micro-partitions.