SnowPro Associate: Platform Question 13
Single answer● Snowflake layersA retail company is evaluating Snowflake for a new analytics platform. The security team wants to understand how Snowflake handles data storage and query processing so they can assess operational risk. During a design review, an architect explains that users will run SQL queries against compute resources without managing servers, while the data itself remains centrally stored and accessible by multiple workloads. Which Snowflake architectural layer is primarily responsible for executing the SQL queries in this scenario?
- A
Database Storage layer
- B
Cloud Services layer
- C
Query Processing layer
- D
Metadata Repository layer
Show answer and explanation
Correct answer: C
Explanation
Snowflake's architecture is commonly described as three layers: Database Storage, Query Processing, and Cloud Services. In this scenario, the key clue is that users run SQL queries using compute resources that are separate from the centrally stored data. That is the role of the Query Processing layer, which uses virtual warehouses to execute workloads. The Database Storage layer stores data, while the Cloud Services layer manages coordination functions such as authentication, metadata, optimization, and transaction management. This separation of storage and compute is a foundational Snowflake design principle and enables independent scaling for different workloads. Refer to Snowflake documentation on Snowflake architecture and virtual warehouses for the standard description of these layers and their responsibilities.
- A. Incorrect.
Incorrect. The Database Storage layer is responsible for storing data in Snowflake's optimized, compressed, columnar format. It persists the table data and manages how that data is organized in storage, but it does not execute SQL queries. A common misconception is to assume that because data is stored here, query execution also occurs here.
- B. Incorrect.
Incorrect. The Cloud Services layer coordinates activities such as authentication, infrastructure management, metadata management, access control, and query optimization. While it plays an important role in supporting query lifecycle operations, it is not the layer that performs the actual compute work of running SQL statements against the data.
- C. Correct.
Correct. The Query Processing layer is the compute layer in Snowflake, implemented through virtual warehouses. It is responsible for executing SQL queries, DML operations, and other compute-intensive tasks. This layer allows users to scale compute independently from storage, which is a core aspect of Snowflake's architecture.
- D. Incorrect.
Incorrect. Metadata is managed as part of Snowflake's services, but there is no separate customer-facing architectural layer called the 'Metadata Repository layer' in the standard Snowflake three-layer architecture. This distractor targets the misconception that metadata management is exposed as its own primary layer alongside storage and compute.