Question 480
After remediating the Snowflake issue, the team reviews: A multi-cluster warehouse has a large fixed minimum cluster count during a quiet overnight period. Which recurring control is most targeted?
Explanation
Correct Answer
Review min and max cluster settings against real hourly demand. This reduces recurrence of: Minimum active clusters set baseline capacity and cost even with low concurrency. The verification should demonstrate: Overnight cluster usage reduces while peak-time workloads still scale within limits.
Incorrect Answers
Correlate client-side timestamps with warehouse queued and execution metrics. That safeguard is aimed at ANOTHER risk: Operations increases warehouse size but sees no reduction in lock-like application-side queueing caused by upstream connection limits. It is less targeted than the control for: Minimum active clusters set baseline capacity and cost even with low concurrency.
Test scheduled automation after warehouse property changes. That safeguard is aimed at ANOTHER risk: A team changes AUTO_RESUME to FALSE on a suspended report warehouse and then schedules automatic queries without explicit starts. It is less targeted than the control for: Minimum active clusters set baseline capacity and cost even with low concurrency.
Review billing dimensions separately for storage, compute and serverless services. That safeguard is aimed at ANOTHER risk: A business unit expects that scaling one warehouse doubles the storage charge for all shared tables. It is less targeted than the control for: Minimum active clusters set baseline capacity and cost even with low concurrency.