Question 140
For this Snowflake situation — A virtual warehouse used for ETL is left running all weekend even though no tasks are scheduled. — the team adopts: Set auto-suspend and inspect task schedules so compute suspends without blocking the next authorized run. Which ongoing practice BEST limits the same problem recurring?
Explanation
Correct Answer
The relevant ongoing safeguard is: Monitor scheduling gaps and warehouse resume failures. It controls the recurring exposure associated with this mechanism: Warehouses are billable compute resources that need not remain active between intermittent workloads. The original action, set auto-suspend and inspect task schedules so compute suspends without blocking the next authorized run., still needs operational checks when the environment or workload changes.
Incorrect Answers
The suggested review tracks a different technical risk: A larger warehouse can provide more compute and memory to a single demanding query. Here the sustained control must address: Warehouses are billable compute resources that need not remain active between intermittent workloads. Choose “Monitor scheduling gaps and warehouse resume failures”.
This routine guards against another mechanism: Snowflake session context affects how unqualified object identifiers are resolved. The recurring exposure in the current case is: Warehouses are billable compute resources that need not remain active between intermittent workloads. The matching preventive check is “Monitor scheduling gaps and warehouse resume failures”.
The suggested review tracks a different technical risk: Dynamic tables express derived-state refresh behavior declaratively rather than requiring every refresh to be scripted. Here the sustained control must address: Warehouses are billable compute resources that need not remain active between intermittent workloads. Choose “Monitor scheduling gaps and warehouse resume failures”.