Warehouse sizes and scaling in Snowflake - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a Snowflake warehouse size?

A Snowflake warehouse size determines the compute power available for queries. Sizes range from X-Small to 6X-Large, with bigger sizes providing more compute resources.

beginner

How does scaling a warehouse affect query performance?

Scaling a warehouse increases the number of servers working in parallel, which can speed up query processing and handle more concurrent users.

intermediate

What is the difference between scaling up and scaling out in Snowflake warehouses?

Scaling up means increasing the size of a single warehouse (more power per server). Scaling out means adding more clusters to handle more queries at the same time.

intermediate

What is multi-cluster warehouse scaling in Snowflake?

Multi-cluster warehouses automatically add or remove clusters based on workload, helping to manage high concurrency without slowing down queries.

beginner

Why should you choose the smallest warehouse size that meets your needs?

Choosing the smallest warehouse size saves cost because Snowflake charges based on compute usage. You can always scale up or out later if needed.

What happens when you increase the size of a Snowflake warehouse?

A It gets more compute power per server

B It adds more clusters automatically

C It reduces storage costs

D It decreases query concurrency

Increasing warehouse size means more compute power per server, speeding up queries.

What does multi-cluster warehouse scaling help with?

A Increasing data retention

B Reducing storage size

C Handling more concurrent queries

D Improving network speed

Multi-cluster scaling adds clusters to handle many queries at once, improving concurrency.

Which warehouse size is the smallest in Snowflake?

A Large

B Small

C Medium

D X-Small

X-Small is the smallest warehouse size in Snowflake.

Scaling out a warehouse means:

A Increasing the size of one server

B Adding more clusters to handle workload

C Reducing the number of queries

D Decreasing compute power

Scaling out means adding more clusters to handle more queries simultaneously.

Why is it best to start with a smaller warehouse size?

A It costs less and can be scaled later

B It has more compute power

C It automatically adds clusters

D It stores more data

Starting small saves cost and you can increase size or clusters as needed.

Explain how warehouse size affects performance and cost in Snowflake.

Think about how bigger sizes mean faster queries but higher cost.

Describe the difference between scaling up and scaling out in Snowflake warehouses.

One changes size, the other adds more clusters.