Question 500
A Snowflake platform team receives the following requirement: A sporadic development warehouse remains running overnight because its AUTO_SUSPEND property was disabled. Which underlying issue should be investigated first?
Explanation
Correct Answer
The described symptoms indicate that an idle running virtual warehouse can continue consuming compute credits. The appropriate resolution is: Enable a suitable auto-suspend interval and auto-resume where permitted. Confirm with: Warehouse history shows suspension after the idle interval and successful restart on demand.
Incorrect Answers
A suspended warehouse loses its local data cache and must warm it again. “Evaluate a suitable auto-suspend interval and monitor data scanned from cache before changing data design” would address that alternative cause, not the condition in this question: an idle running virtual warehouse can continue consuming compute credits.
“Review the service-specific billing and scheduling controls rather than relying only on warehouse suspension” responds to this separate finding: serverless services can consume managed compute independently of a user warehouse. This question instead needs “Enable a suitable auto-suspend interval and auto-resume where permitted”, so the alternative does not meet the stated condition.
Database object privileges do not automatically grant USAGE on compute warehouses. “Grant the appropriately scoped warehouse USAGE privilege to the authorized execution role” applies to that separate problem. The observed case is a sporadic development warehouse remains running overnight because its AUTO_SUSPEND property was disabled; choosing this alternative would address the wrong failure mode.