Snowpro Core · Free Practice Question Medium
Question 72
Snowflake stores which of the following metadata about data in a micro-partition. Select all that apply.
- A The number of distinct values.
- B The range of values for each of the columns in the micro-partition.
- C Additional properties for optimization and efficient processing.
Reveal correct answers
Correct answers: A, B, C
Explanation
All of these are valid examples of the metadata that Snowflake stores for micro-partition. 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.
