SnowPro Core Certification — Question 1212

Which virtual warehouse configuration is recommended specifically for a steady workload that has no execution lag?

Answer options

• A. AUTO_RESUME = FALSE
• B. AUTO_SUSPEND = 0
• C. STATEMENT_TIMEOUT_IN_SECONDS = 3600
• D. MIN_CLUSTER_COUNT = 1 - MAX_CLUSTER_COUNT = 3

Correct answer: B

Explanation

The correct answer, B, indicates that setting AUTO_SUSPEND to 0 keeps the warehouse active continuously without suspending, which is ideal for a steady workload. Option A would cause the warehouse to not resume automatically, leading to potential delays. Option C sets a timeout limit for statements, which isn't necessary for a steady workload without execution lag. Option D specifies a minimum and maximum cluster count, but does not directly address the need for continuous operation.