SOL-C01 · Question #133
SOL-C01 Question #133: Real Exam Question with Answer & Explanation
The correct answer is A: The warehouse will automatically suspend after 5 minutes of inactivity.. The warehouse will auto-suspend after 300 seconds (5 minutes) of inactivity (A). = 1 ensures at least one active cluster (B). = 3' allows scaling to three clusters (C). 'SCALING_POLICY = 'ECONOMY" prioritizes cost savings over immediate performance during scaling (D). 'WAREHOUSE_
Question
Consider the following Snowflake warehouse definition: 'CREATE OR REPLACE WAREHOUSE MY WAREHOUSE WITH WAREHOUSE SIZE = 'MEDIUM' WAREHOUSE TYPE = 'STANDARD' AUTO SUSPEND = 300 AUTO RESUME = TRUE MIN CLUSTER_COUNT = 1 MAX CLUSTER_COUNT = 3 SCALING_POLICY = 'ECONOMY;' Which of the following statements are TRUE regarding this warehouse? (Select all that apply)
Options
- AThe warehouse will automatically suspend after 5 minutes of inactivity.
- BThe warehouse will always have at least one active cluster.
- CThe warehouse can scale up to a maximum of three clusters to handle concurrent queries.
- DThe warehouse is optimized for minimizing costs rather than maximizing performance when
- EThe 'WAREHOUSE_TYPE = 'STANDARD" setting is invalid and will cause an error.
Explanation
The warehouse will auto-suspend after 300 seconds (5 minutes) of inactivity (A). = 1 ensures at least one active cluster (B). = 3' allows scaling to three clusters (C). 'SCALING_POLICY = 'ECONOMY" prioritizes cost savings over immediate performance during scaling (D). 'WAREHOUSE_TYPE = 'STANDARD' is a valid setting, it defines the warehouse as using the standard model for resource management.
Topics
Community Discussion
No community discussion yet for this question.