Snowflake architecture (storage, compute, services layers) - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Identify the Snowflake layer responsible for data storage

Which layer in Snowflake architecture is designed to store all the data persistently and separately from compute resources?

A Compute layer

B Storage layer

C Network layer

D Services layer

💡 Hint

Think about where your data files are kept safely in the cloud.

The storage layer in Snowflake holds all the data in cloud storage, separate from compute and services layers.

🧠 Conceptual

intermediate

Role of the Compute layer in Snowflake

What is the main function of the compute layer in Snowflake's architecture?

A Executing queries and processing data

B Handling network traffic and routing

C Storing data files in cloud storage

D Managing user authentication and metadata

💡 Hint

This layer does the actual work when you run a query.

The compute layer runs queries and processes data using virtual warehouses.

❓ Architecture

advanced

Services layer responsibilities in Snowflake

Which of the following is NOT a responsibility of the services layer in Snowflake architecture?

A Transaction management and metadata handling

B Security and access control

C Query parsing and optimization

D Physical storage of data files

💡 Hint

Think about which layer handles metadata versus actual data storage.

The services layer manages metadata, security, and query optimization but does not store data physically.

❓ service_behavior

advanced

Effect of scaling compute warehouses on Snowflake performance

If you increase the size or number of compute warehouses in Snowflake, what is the expected effect on query performance and storage costs?

A Query performance improves; storage costs remain unchanged

B Query performance improves; storage costs increase

C Query performance remains unchanged; storage costs increase

D Query performance decreases; storage costs remain unchanged

💡 Hint

Compute and storage are separate; changing one does not affect the other.

Increasing compute resources speeds up queries but does not affect storage costs since storage is separate.

❓ security

expert

Which Snowflake layer enforces access control and manages user sessions?

In Snowflake's architecture, which layer is responsible for enforcing security policies, managing user authentication, and controlling access to data?

A Compute layer

B Storage layer

C Services layer

D Network layer

💡 Hint

This layer acts like the gatekeeper for users and permissions.

The services layer handles security, user sessions, and access control in Snowflake.