Question 1
At a retail analytics group, a Snowflake implementation review finds: A reporting dashboard slows during warehouse saturation, and an analyst proposes resizing cloud services instead of compute. Which action best addresses this requirement?
Explanation
Correct Answer
Increase or isolate the virtual warehouse handling reporting queries after measuring its actual load. This directly addresses the described Snowflake condition: A reporting dashboard slows during warehouse saturation, and an analyst proposes resizing cloud services instead of compute. The mechanism is: Query execution uses virtual warehouse compute, while metadata coordination runs in Snowflake cloud services. Verify success using: The reporting warehouse completes the sample dashboard while cloud services metadata operations remain unaffected.
Incorrect Answers
Separate warehouse compute consumption from storage billing when estimating cost impacts of resizing. That is suitable for a DIFFERENT Snowflake situation: A business unit expects that scaling one warehouse doubles the storage charge for all shared tables. It does not directly resolve the current requirement: A reporting dashboard slows during warehouse saturation, and an analyst proposes resizing cloud services instead of compute.
Show the three layers separately: managed storage, virtual warehouse compute, and cloud services coordination. That is suitable for a DIFFERENT Snowflake situation: An architecture slide describes Snowflake's services layer as storing every table's raw compressed micro-partitions. It does not directly resolve the current requirement: A reporting dashboard slows during warehouse saturation, and an analyst proposes resizing cloud services instead of compute.
Enable AUTO_RESUME or add an explicit supervised resume step ahead of the query job. That is suitable for a DIFFERENT Snowflake situation: A team changes AUTO_RESUME to FALSE on a suspended report warehouse and then schedules automatic queries without explicit starts. It does not directly resolve the current requirement: A reporting dashboard slows during warehouse saturation, and an analyst proposes resizing cloud services instead of compute.