SOL-C01 · Question #162
You have created a virtual warehouse in Snowflake and loaded data into several tables. You observe that query performance is inconsistent, with some queries running quickly and others taking…
The correct answer is A. Increase the size of the virtual warehouse to provide more computing resources. B. Enable query acceleration to offload suitable workloads and reduce warehouse load. C. Create separate virtual warehouses for different workloads (e.g., data loading, reporting) to isolate D. Implement workload management rules to prioritize critical queries and limit resource consumption. All four correct options (A, B, C, D) directly address resource contention by either expanding available compute capacity or intelligently distributing workload. A (increasing warehouse size) adds more CPUs and memory, reducing competition for resources among concurrent…
Question
You have created a virtual warehouse in Snowflake and loaded data into several tables. You observe that query performance is inconsistent, with some queries running quickly and others taking significantly longer, even though they access similar data. You suspect resource contention is the issue. What steps can you take to improve query performance and manage resource contention effectively? Select all that apply.
Options
- AIncrease the size of the virtual warehouse to provide more computing resources.
- BEnable query acceleration to offload suitable workloads and reduce warehouse load.
- CCreate separate virtual warehouses for different workloads (e.g., data loading, reporting) to isolate
- DImplement workload management rules to prioritize critical queries and limit resource consumption
- EReduce the number of concurrent users accessing the system.
How the community answered
(26 responses)- A54% (14)
- E46% (12)
Explanation
All four correct options (A, B, C, D) directly address resource contention by either expanding available compute capacity or intelligently distributing workload. A (increasing warehouse size) adds more CPUs and memory, reducing competition for resources among concurrent queries. B (query acceleration) offloads eligible partial workloads to a serverless compute layer, freeing warehouse resources for other queries. C (separate warehouses per workload) eliminates contention at its root by ensuring data loading jobs don't compete with reporting queries for the same compute pool. D (workload management rules) lets you set query priorities and resource limits, preventing any single workload from monopolizing the warehouse.
E is wrong because reducing concurrent users is an organizational workaround, not a technical solution - Snowflake is designed to handle concurrency, and the platform provides proper tools (options A–D) to manage it without restricting legitimate users.
Memory tip: Think of the four correct answers as the "WISE" strategy - Warehouse sizing, Isolation (separate warehouses), Special acceleration, and Enforcement (workload rules). Any answer that avoids the technical tools and just tells people to "use it less" won't appear on a Snowflake performance exam.
Topics
Community Discussion
No community discussion yet for this question.