COF-C02 Question 156

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose B1

  Snowflake's Global Services Layer manages metadata, which includes statistics about the data stored in micro-partitions. However, it does not gather and maintain statistics on all columns in all micro-partitions. Snowflake automatically collects metadata and statistics to optimize query performance. It does this continuously in the background, analyzing data as it's loaded and as queries are executed. While it gathers essential statistics, it's unnecessary and inefficient to maintain detailed statistics for every single column in every micro-partition. Snowflake focuses on collecting statistics that are most useful for query optimization, such as: Value ranges within columns. The number of distinct values (approximate). Information about NULL values.

• Chose A3

  The answer is A. True. Let's explain why this is true: Snowflake's Global Services Layer: - Automatically gathers statistics on ALL columns - Maintains statistics for ALL micro-partitions - This is done without DBA intervention - Used for query optimization Key points about statistics collection: - Continuous and automatic process - Covers every column in every micro-partition - No manual statistics gathering needed - Used by query optimizer for efficient execution plans For the SnowPro Core exam, remember: - Statistics collection is automatic - No DBA maintenance required - Covers all columns and micro-partitions - This is a key differentiator from traditional databases - Helps with query optimization and performance - Part of Snowflake's cloud-native architecture benefits This automatic statistics gathering is one of Snowflake's key features that helps with query optimization and maintenance-free operations.

• 1

  ● Micro-partition level metadata ○ Row count ● Micro-partition column-level metadata ○ MIN and MAX values ○ Number of DISTINCT values ○ Number of NULL values