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

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.

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.

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).