SOL-C01 practice question 16 of 30

Which of the following are benefits of using a multi-cluster warehouse in Snowflake? (Choose any 2 options)

Full set: 214 questions
Answer options
A: Reduced storage costs
B: Improved concurrency for handling many simultaneous queries Correct answer
C: Automatic scaling to meet varying query loads Correct answer
D: Faster data loading
Correct Answer:
B. Improved concurrency for handling many simultaneous queries; C. Automatic scaling to meet varying query loads
Explanation

A multi-cluster virtual warehouse is designed specifically to handle concurrency and fluctuating workloads. It improves concurrency by automatically starting additional clusters to run queries simultaneously as the user load increases. This process of adding and removing clusters based on the query queue is known as automatic scaling, ensuring that performance remains consistent even with a high number of simultaneous users and queries.

Why Incorrect

A: Storage costs are billed separately from compute costs in Snowflake. Multi-cluster warehouses affect compute credits consumed, not storage costs. D: The speed of a single data loading operation is determined by the warehouse size (e.g., X-Large), not its multi-cluster configuration.

References

1. Snowflake Documentation. (n.d.). Multi-cluster Virtual Warehouses. Retrieved from https://docs.snowflake.com/en/user-guide/warehouses-multicluster. (This document states, "multi-cluster virtual warehouses are designed specifically for handling queuing and performance issues related to large numbers of concurrent users and/or queries.").

2. Snowflake Documentation. (n.d.). Virtual Warehouse Credit Usage. Retrieved from https://docs.snowflake.com/en/user-guide/warehouses-credits. (This page explains how warehouse usage is billed, showing its separation from storage).

Scroll to Top