SOL-C01 · Question #132
SOL-C01 Question #132: Real Exam Question with Answer & Explanation
The correct answer is B: Create two separate virtual warehouses: one for ETL and one for reporting.. Creating separate warehouses isolates the ETL and reporting workloads, preventing resource contention. This ensures that reporting queries have dedicated compute resources, even during peak ETL hours. Increasing the warehouse size (option A) is a less targeted approach and may be
Question
A data team is using a Snowflake virtual warehouse for both ETL processes and ad-hoc reporting. During peak ETL hours, reporting queries are significantly slowed down. What is the BEST strategy to mitigate this issue without over-provisioning resources?
Options
- AIncrease the size of the existing warehouse to X-Large.
- BCreate two separate virtual warehouses: one for ETL and one for reporting.
- CSchedule all reporting queries to run outside of ETL hours.
- DReduce the concurrency level of the ETL processes.
- EEnable resource monitors to limit the credit usage of reporting queries.
Explanation
Creating separate warehouses isolates the ETL and reporting workloads, preventing resource contention. This ensures that reporting queries have dedicated compute resources, even during peak ETL hours. Increasing the warehouse size (option A) is a less targeted approach and may be more expensive. Scheduling queries (option C) might not be feasible for ad-hoc reporting. Reducing ETL concurrency (option D) might impact ETL completion time. Resource monitors (option E) limit credit usage but don't improve query performance if the warehouse is already
Topics
Community Discussion
No community discussion yet for this question.