Question 180
During a Snowflake architecture review, the team finds: A worksheet query fails because its selected warehouse is suspended and auto-resume is disabled for that workload. Which explanation best accounts for the observed behavior?
Explanation
Correct Answer
The described symptoms indicate that the session has no running compute and the warehouse will not automatically restart. The appropriate resolution is: Resume the approved warehouse or enable auto-resume where governance allows it. Confirm with: The same authorized query executes after the warehouse becomes running.
Incorrect Answers
Warehouse resource monitors do not provide universal spend control for all Snowflake services. “Apply a resource monitor to eligible warehouse usage and separately manage other service budgets” would address that alternative cause, not the condition in this question: the session has no running compute and the warehouse will not automatically restart.
“Treat result-cache eligibility as conditional and remeasure execution after data changes” responds to this separate finding: changes to underlying data can invalidate eligibility for persisted result reuse. This question instead needs “Resume the approved warehouse or enable auto-resume where governance allows it”, so the alternative does not meet the stated condition.
Economy scaling may tolerate more queuing to conserve compute credits. “Use a scaling policy aligned with queue-latency requirements and measure the tradeoff” applies to that separate problem. The observed case is a worksheet query fails because its selected warehouse is suspended and auto-resume is disabled for that workload; choosing this alternative would address the wrong failure mode.