Question 540
For this Snowflake situation — A multi-cluster warehouse expands to its maximum cluster count during modest activity and exceeds budget. — the team adopts: Review the standard versus economy scaling policy and size limits against actual latency requirements. Which ongoing practice BEST limits the same problem recurring?
Explanation
Correct Answer
The relevant ongoing safeguard is: Review credit and queue metrics whenever warehouse scaling policy changes. It controls the recurring exposure associated with this mechanism: Scaling policies influence how aggressively multi-cluster compute expands and retires. The original action, review the standard versus economy scaling policy and size limits against actual latency requirements., still needs operational checks when the environment or workload changes.
Incorrect Answers
That safeguard is relevant to: Auto-suspend stops active warehouse compute between uses without dropping Snowflake tables. The current failure instead follows from: Scaling policies influence how aggressively multi-cluster compute expands and retires. Its prevention measure is “Review credit and queue metrics whenever warehouse scaling policy changes”.
The suggested review tracks a different technical risk: The persisted query result cache may satisfy eligible repeat executions without rerunning warehouse computation. Here the sustained control must address: Scaling policies influence how aggressively multi-cluster compute expands and retires. Choose “Review credit and queue metrics whenever warehouse scaling policy changes”.
That safeguard is relevant to: CTEs organize query logic but do not themselves guarantee materialization or faster execution. The current failure instead follows from: Scaling policies influence how aggressively multi-cluster compute expands and retires. Its prevention measure is “Review credit and queue metrics whenever warehouse scaling policy changes”.