
Answer-first summary for fast verification
Answer: Use a multi-cluster warehouse.
The question asks how to configure a virtual warehouse to support concurrent usage by over 100 users with Enterprise Edition. Option C (Use a multi-cluster warehouse) is the correct answer because multi-cluster warehouses are specifically designed to handle high concurrency by automatically scaling out to multiple clusters when query load increases. This allows multiple users to run queries simultaneously without queuing. The community discussion strongly supports this with 78% choosing C and multiple comments explaining that multi-cluster warehouses are the solution for simultaneous querying and concurrency. Option A is incorrect because simply adding warehouses doesn't automatically handle load balancing for concurrent users. Option B (auto-scale to 100) is not a valid Snowflake configuration. Option D (larger warehouse) would improve performance for individual queries but doesn't inherently solve the concurrency problem for 100+ users.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can a Snowflake user configure a virtual warehouse to support concurrent usage by over 100 users with an Enterprise Edition account?
A
Add additional warehouses and configure them as a cluster.
B
Set the auto-scale to 100.
C
Use a multi-cluster warehouse.
D
Use a larger warehouse.
No comments yet.