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.

Practice

1. Which layer in Snowflake architecture is responsible for storing data securely in the cloud?

easy

A. Network layer

B. Storage layer

C. Services layer

D. Compute layer

Solution

1. Step 1: Understand Snowflake layers

   Snowflake architecture has three main layers: storage, compute, and services.

2. Step 2: Identify the storage role

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

3. Final Answer:

   Storage layer -> Option B

4. Quick Check:

   Storage = Data storage [OK]

Hint: Storage layer always holds your data safely [OK]

Common Mistakes:

• Confusing compute with storage
• Thinking services store data
• Selecting network layer which doesn't exist in Snowflake

2. Which Snowflake layer runs queries and can scale independently?

easy

A. Compute layer

B. Services layer

C. Storage layer

D. Security layer

Solution

1. Step 1: Recall Snowflake layers

   Snowflake separates compute, storage, and services layers.

2. Step 2: Identify compute layer role

   The compute layer runs queries and can scale up or down independently from storage.

3. Final Answer:

   Compute layer -> Option A

4. Quick Check:

   Compute = Runs queries [OK]

Hint: Compute layer runs queries and scales [OK]

Common Mistakes:

• Choosing storage for query execution
• Confusing services with compute
• Selecting security layer which is not a main layer

3. Given Snowflake's architecture, what happens if you pause a compute warehouse?

medium

A. Data in storage is deleted

B. Services layer shuts down

C. Compute and storage both pause

D. Queries stop running but data remains intact

Solution

1. Step 1: Understand compute warehouse pause

   Pausing compute stops query processing but does not affect stored data.

2. Step 2: Analyze impact on storage and services

   Storage remains active and data is safe; services continue managing metadata and security.

3. Final Answer:

   Queries stop running but data remains intact -> Option D

4. Quick Check:

   Pause compute = stop queries, keep data [OK]

Hint: Pausing compute stops queries, storage stays safe [OK]

Common Mistakes:

• Thinking data is deleted on pause
• Assuming services layer stops
• Believing storage also pauses

4. A user reports slow query performance. Which Snowflake layer should you check first for scaling issues?

medium

A. Compute layer

B. Storage layer

C. Services layer

D. Network layer

Solution

1. Step 1: Identify cause of slow queries

   Slow queries usually relate to compute resources being insufficient.

2. Step 2: Check compute layer scaling

   Compute layer runs queries and can be scaled up or out to improve performance.

3. Final Answer:

   Compute layer -> Option A

4. Quick Check:

   Slow queries? Check compute scaling [OK]

Hint: Slow queries? Scale compute layer first [OK]

Common Mistakes:

• Checking storage for query speed
• Blaming services layer for performance
• Selecting network layer which is not part of Snowflake

5. How does Snowflake's services layer contribute to security and metadata management?

hard

A. It stores all user data and query results

B. It runs queries and manages compute resources

C. It manages authentication, metadata, and transaction coordination

D. It handles physical storage of data files

Solution

1. Step 1: Understand services layer role

   The services layer manages security, metadata, and coordinates transactions.

2. Step 2: Differentiate from storage and compute

   Storage holds data; compute runs queries; services handle control tasks like authentication and metadata.

3. Final Answer:

   It manages authentication, metadata, and transaction coordination -> Option C

4. Quick Check:

   Services = Security + metadata + coordination [OK]

Hint: Services layer controls security and metadata [OK]

Common Mistakes:

• Thinking services store data
• Confusing compute with services
• Assuming services run queries