Snowpro Core · Free Practice Question Medium
Question 43
What type of metadata is maintained for each micro-partition? Select all that apply.
- A Count of distinct values for each column
- B Range of column values
- C Maximum & minimum of each column
- D Mean, median & mode of each column
Reveal correct answers
Correct answers: A, B, C
Explanation
Snowflake stores the range of column values in its metadata: the maximum and the minimum value for each column in each micro-partition. Snowflake can intelligently decide which partitions to read when processing a query using this metadata. Additionally, Snowflake stores the count of distinct values for each column in each partition in the metadata and certain other information to assist in query optimization. https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitionsDiscussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
