Answer-first summary for fast verification
Answer: The number of distinct values, The minimum and maximum values for each of the columns
The question asks for two types of metadata stored for each micro-partition in Snowflake. Based on Snowflake documentation and community consensus, the correct answers are A (The number of distinct values) and E (The minimum and maximum values for each of the columns). These are the key statistical metadata types that Snowflake stores per micro-partition to enable efficient query pruning and optimization. Option D is incorrect because it refers to the range of values for the full table, not per micro-partition. Option B (clustering key) is not metadata stored per micro-partition but rather a table property. Option C (average depth of values) is not a recognized metadata type in Snowflake's micro-partition system.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which two types of metadata are stored for each micro-partition?
A
The number of distinct values
B
The clustering key used in the table
C
The average depth of values for each of the columns
D
The range of values for each of the columns in the full table
E
The minimum and maximum values for each of the columns
No comments yet.