SnowPro Core Certification — Question 144

What parameter controls if the Virtual Warehouse starts immediately after the CREATE WAREHOUSE statement?

Answer options

• A. INITIALLY_SUSPENDED = TRUE/FALSE
• B. START_AFTER_CREATE = TRUE/FALSE
• C. START_THE = 60 // (seconds from now)
• D. START_TIME = CURRENT_DATE()

Correct answer: A

Explanation

The correct answer is A, as the INITIALLY_SUSPENDED parameter specifies if the warehouse should start immediately or remain suspended. The other options do not control the immediate start of the warehouse after its creation: B suggests a non-existent parameter, C is about a delay, and D relates to a specific time setting.