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 command

Question

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

• A
  94% (33)
• B
  3% (1)
• D
  3% (1)

Explanation

Option A is correct because Snowflake's AUTO_SUSPEND parameter accepts a value in seconds, so 10 minutes must be expressed as 600 (10 × 60), and AUTO_RESUME = TRUE enables the warehouse to wake automatically when a query arrives - together these two ALTER WAREHOUSE statements achieve exactly what the question asks.

Why the distractors fail:

• B sets AUTO_SUSPEND = TRUE, which is invalid - the parameter expects an integer number of seconds, not a boolean.
• D sets AUTO_SUSPEND = 10, which means 10 seconds of inactivity, not 10 minutes - a common unit confusion trap.
• C and E appear structurally similar to A but likely have an incorrect AUTO_RESUME value (e.g., FALSE or missing), which would prevent the warehouse from waking on query submission.

Memory tip: Think of Snowflake's suspend timer like a stopwatch measured in seconds - always convert minutes to seconds (minutes × 60), and remember the pair: AUTO_SUSPEND = <seconds> controls when it sleeps, AUTO_RESUME = TRUE controls whether it wakes up.

No community discussion yet for this question.