What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
A . The ability to scale up warehouses
B . The use of warehouse auto scaling
C . The ability to resize warehouses
D . Use of multi-clustered warehouses
E . The use of warehouse indexing

View Answer

Answer: B, D

Explanation:

Snowflake’s architecture is designed to handle high concurrency workloads through several features, two of which are particularly effective:

B. The use of warehouse auto scaling: This feature allows Snowflake to automatically adjust the compute resources allocated to a virtual warehouse in response to the workload. If there is an increase in concurrent queries, Snowflake can scale up the resources to maintain performance.

D. Use of multi-clustered warehouses: Multi-clustered warehouses enable Snowflake to run multiple clusters of compute resources simultaneously. This allows for the distribution of queries across clusters, thereby reducing the load on any single cluster and improving the system’s ability to handle a high number of concurrent queries.

These features ensure that Snowflake can manage varying levels of demand without manual intervention, providing a seamless experience even during peak usage.

Reference: Snowflake Documentation on Virtual Warehouses

SnowPro® Core Certification Study Guide