SOL-C01 · Question #138
SOL-C01 Question #138: Real Exam Question with Answer & Explanation
The correct answer is B: Use one virtual warehouse sized for the ETL workload and another, smaller virtual warehouse for. Using separate warehouses allows you to size each warehouse appropriately for its specific workload. A larger warehouse can handle the ETL processing, while a smaller warehouse can serve ad-hoc queries. Configuring resource monitors adds another layer of cost control. Option A ca
Question
A Snowflake environment hosts two distinct workloads: daily ETL processes that require significant compute power and ad-hoc analytical queries from business users. You want to optimize cost and performance for each workload. Which of the following virtual warehouse configurations would be the MOST effective approach?
Options
- AUse a single, large virtual warehouse for both ETL and ad-hoc queries, with auto-suspend
- BUse one virtual warehouse sized for the ETL workload and another, smaller virtual warehouse for
- CUse a single, small virtual warehouse for both ETL and ad-hoc queries to minimize cost.
- DUse a single, large virtual warehouse for ETL and disable auto-suspend to ensure consistent
- EUse separate virtual warehouses for ETL and ad-hoc queries, and configure resource monitors to
Explanation
Using separate warehouses allows you to size each warehouse appropriately for its specific workload. A larger warehouse can handle the ETL processing, while a smaller warehouse can serve ad-hoc queries. Configuring resource monitors adds another layer of cost control. Option A can lead to contention and inefficient resource utilization. Option C will likely result in poor performance for ETL. Option D wastes credits by keeping the large warehouse running
Topics
Community Discussion
No community discussion yet for this question.