COF-C02 · Question #3
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
The correct answer is B. The use of warehouse auto scaling: This feature allows Snowflake to automatically adjust the D. Use of multi-clustered warehouses: Multi-clustered warehouses enable Snowflake to run. High concurrency is addressed by: (B) warehouse auto-scaling, which automatically adds or removes clusters within a multi-cluster warehouse based on current query demand, and (D) multi-cluster warehouses, which allow multiple clusters of compute resources to run in parallel so…
Question
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
Options
- AThe ability to scale up warehouses
- BThe use of warehouse auto scaling: This feature allows Snowflake to automatically adjust the
- CThe ability to resize warehouses
- DUse of multi-clustered warehouses: Multi-clustered warehouses enable Snowflake to run
- EThe use of warehouse indexing
How the community answered
(47 responses)- A2% (1)
- B91% (43)
- C2% (1)
- E4% (2)
Explanation
High concurrency is addressed by: (B) warehouse auto-scaling, which automatically adds or removes clusters within a multi-cluster warehouse based on current query demand, and (D) multi-cluster warehouses, which allow multiple clusters of compute resources to run in parallel so many queries can execute simultaneously. Scaling up (A) or resizing (C) a warehouse increases the compute power per query but does not add concurrency - it helps with query performance, not the number of simultaneous queries. Option E (warehouse indexing) does not exist as a Snowflake feature.
Topics
Community Discussion
No community discussion yet for this question.