Snowflake architecture (storage, compute, services layers) - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to identify the layer responsible for storing data in Snowflake architecture.

Snowflake

The [1] layer in Snowflake handles all persistent data storage.

Drag options to blanks, or click blank then click option'

Aservices

Bcompute

Cnetwork

Dstorage

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing compute with storage

Thinking services layer stores data

The storage layer is responsible for storing all data persistently in Snowflake.

2fill in blank

medium

Complete the code to name the layer that performs query processing in Snowflake.

Snowflake

The [1] layer executes queries and performs computations.

Drag options to blanks, or click blank then click option'

Aservices

Bcompute

Cmetadata

Dstorage

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing compute with services

Choosing storage instead of compute

The compute layer runs the virtual warehouses that process queries.

3fill in blank

hard

Fix the error in naming the Snowflake layer that manages security and metadata.

Snowflake

The [1] layer manages authentication, metadata, and infrastructure management.

Drag options to blanks, or click blank then click option'

Astorage

Bcompute

Cservices

Dnetwork

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing services with compute

Choosing storage for metadata management

The services layer handles security, metadata, and infrastructure tasks.

4fill in blank

hard

Fill both blanks to describe Snowflake's separation of layers.

Snowflake

Snowflake separates [1] from [2] to allow independent scaling.

Drag options to blanks, or click blank then click option'

Acompute

Bnetwork

Cstorage

Dservices

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing services with storage

Choosing network instead of storage

Compute is separated from storage so they can scale independently.

5fill in blank

hard

Fill all three blanks to complete the description of Snowflake's architecture layers.

Snowflake

The [1] layer stores data, the [2] layer runs queries, and the [3] layer manages security and metadata.

Drag options to blanks, or click blank then click option'

Astorage

Bcompute

Cservices

Dnetwork

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping compute and services

Including network as a main layer

Storage holds data, compute processes queries, and services manage security and metadata.

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