Exam SnowPro Core topic 1 question 92 discussion

The Global Services Layer in Snowflake is responsible for several tasks including authentication, infrastructure management, metadata management, query parsing and optimization, and access control​1​. However, the documentation does not specifically mention that it gathers and maintains statistics on all columns in all micro-partitions.

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.

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

B.False,Snowflake's Global Services Layer gathers and maintains statistics on columns in micro-partitions, but it does not gather and maintain statistics on all columns in all micro-partitions

Snowflake's Global Services Layer does not gather and maintain statistics on all columns in all micro-partitions. Instead, it dynamically gathers statistics as needed for query optimization, utilizing metadata and sampling techniques to optimize query performance.

https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions#what-are-micro-partitions

No definition of Global Services Layer, it should be cloud services layer Snowflake stores metadata about all rows stored in a micro-partition, not columns

https://www.snowflake.com/wp-content/uploads/2014/10/A-Detailed-View-Inside-Snowflake.pdf It clearly says the service layer saves the metadata about the stored data in snowflake. Page 7, right column.

"Snowflake stores metadata about all rows stored in a micro-partition, including: - The range of values for each of the columns in the micro-partition. - The number of distinct values. - Additional properties used for both optimization and efficient query processing." Seems to me that this is done by the Cloud Services layer, and this "Global Services layer" looks like another term for it: https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions#what-are-micro-partitions

Cloud services layer is als https://blog.devgenius.io/snowflake-series-part-1-snowflake-architecture-deep-dive-3a9ca082a531o called global services layer

https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions

B . FALSE Cloud Services If Snowflake’s computing layer is the brawn of our solution, our cloud services layer is the brain. Snowflake’s cloud services manage client sessions, metadata, transactions, query planning, security/governance and many other services. It’s also a highly scalable tier thanks to the near-limitless computing resources in the cloud. Snowflake supports thousands of customer accounts and hundreds of millions of queries each and every day.

There is no Global Services Layer in snowflake. https://www.bing.com/search?q=snowflake+global+services+layer&qs=NM&pq=what+is+global+services+layer+in+snowflake&sc=6-42&cvid=9660BE0F9FA3415AB5F2EF9404F1C104&FORM=QBRE&sp=1&ghc=2&lq=0

B is correct, question is about micro-partitions, documentation explains it keeps metadata about rows, not columns, so is false.

https://www.snowflake.com/product/architecture/ Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated. Data workloads scale independently from one another, making it an ideal platform for data warehousing, data lakes, data engineering, data science, modern data sharing, and developing data applications.

B is correct

Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and GLOBAL SERVICES LAYERS https://www.snowflake.com/product/architecture/