SOL-C01 · Question #76
SOL-C01 Question #76: Real Exam Question with Answer & Explanation
The correct answer is A: ALTER WAREHOUSE ANALYTICS_WH SET AUTO SUSPEND = 600; ALTER WAREHOUSE. The 'AUTO_SUSPEND parameter controls the number of seconds of inactivity before a warehouse is automatically suspended. 10 minutes is equal to 600 seconds. 'AUTO RESUME' set to 'TRUE' enables the warehouse to automatically resume when a query is submitted. Option B is incorrect b
Question
You need to configure Snowflake to automatically suspend a virtual warehouse named `ANALYTICS after 10 minutes of inactivity and resume it when a query is submitted. Which of the following SQL commands achieve this?
Options
- AALTER WAREHOUSE ANALYTICS_WH SET AUTO SUSPEND = 600; ALTER WAREHOUSE
- B`sql ALTER WAREHOUSE ANALYTICS WH SET AUTO SUSPEND = TRUE; ALTER
- CALTER WAREHOUSE ANALYTICS_WH SET AUTO SUSPEND = 600; ALTER WAREHOUSE
- D`sql ALTER WAREHOUSE ANALYTICS WH SET AUTO SUSPEND = 10; ALTER WAREHOUSE
- EALTER WAREHOUSE ANALYTICS_WH SET AUTO SUSPEND = 600; ALTER WAREHOUSE
Explanation
The 'AUTO_SUSPEND parameter controls the number of seconds of inactivity before a warehouse is automatically suspended. 10 minutes is equal to 600 seconds. 'AUTO RESUME' set to 'TRUE' enables the warehouse to automatically resume when a query is submitted. Option B is incorrect because "INACTIVITY _ TIMEOUT does not exist. Option C is incorrect as "AUTO_RESUME' only accepts boolean values. Option D is incorrect as auto suspend is configured for only 10 seconds. Option E is unnecessarily complicated, the core functionality is achieved by the two commands in option A. Setting initial warehouse size is an optimization, not essential for auto resume to function.
Topics
Community Discussion
No community discussion yet for this question.