Multi-cluster warehouses in Snowflake - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a multi-cluster warehouse in Snowflake?

A multi-cluster warehouse is a compute resource in Snowflake that can automatically start and stop multiple clusters to handle varying query loads, improving performance and concurrency.

intermediate

How does Snowflake decide when to add or remove clusters in a multi-cluster warehouse?

Snowflake adds clusters when query load increases and removes clusters when load decreases, based on user activity and concurrency to optimize resource use and cost.

beginner

What are the benefits of using multi-cluster warehouses?

They provide better concurrency handling, reduce query queuing, and maintain consistent performance during peak workloads by scaling compute resources automatically.

intermediate

What is the difference between a single-cluster and a multi-cluster warehouse?

A single-cluster warehouse has one compute cluster and can become a bottleneck under high load, while a multi-cluster warehouse can run multiple clusters simultaneously to handle more queries.

intermediate

How do you configure a multi-cluster warehouse in Snowflake?

You set the warehouse size and specify the minimum and maximum number of clusters to allow Snowflake to auto-scale between these limits based on workload.

What triggers Snowflake to add a new cluster in a multi-cluster warehouse?

A Manual user request only

B Scheduled time intervals

C Increased query load causing queuing

D When storage usage is high

Snowflake automatically adds clusters when query load increases and queries start to queue, to improve performance.

Which of the following is NOT a benefit of multi-cluster warehouses?

A Reduced storage costs

B Automatic scaling of compute resources

C Consistent query performance during peak times

D Improved query concurrency

Multi-cluster warehouses improve compute scaling and concurrency but do not directly reduce storage costs.

What happens when the workload decreases in a multi-cluster warehouse?

A Nothing changes automatically

B Snowflake stops all clusters immediately

C Snowflake increases cluster size

D Snowflake reduces the number of active clusters

Snowflake automatically reduces the number of active clusters to save resources when workload decreases.

How do you limit the number of clusters in a multi-cluster warehouse?

A By disabling auto-scaling

B By setting minimum and maximum cluster counts

C By setting storage limits

D By setting query timeout

You configure the minimum and maximum number of clusters to control auto-scaling limits.

Which warehouse type can become a bottleneck under high query load?

A Single-cluster warehouse

B Multi-cluster warehouse

C Virtual warehouse

D Cloud storage warehouse

Single-cluster warehouses have only one cluster and can become bottlenecks when many queries run simultaneously.

Explain how a multi-cluster warehouse manages varying workloads in Snowflake.

Think about how Snowflake adjusts compute resources based on query demand.

Describe the key differences between single-cluster and multi-cluster warehouses.

Focus on how many clusters run and how they affect query handling.