nerdexam
Snowflake

COF-C02 · Question #434

What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?

The correct answer is C. 10 minutes. When creating a virtual warehouse through the Snowflake Web UI, the default auto-suspend setting is 10 minutes of inactivity. After 10 minutes without executing any queries, the warehouse is automatically suspended to stop consuming credits. This default balances responsiveness…

Performance Management

Question

What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?

Options

  • A1 minutes
  • B5 minutes
  • C10 minutes
  • D15 minutes

How the community answered

(29 responses)
  • A
    7% (2)
  • B
    3% (1)
  • C
    86% (25)
  • D
    3% (1)

Explanation

When creating a virtual warehouse through the Snowflake Web UI, the default auto-suspend setting is 10 minutes of inactivity. After 10 minutes without executing any queries, the warehouse is automatically suspended to stop consuming credits. This default balances responsiveness (avoiding cold starts) with cost efficiency. Auto-suspend can be configured to any value from 60 seconds upward, or disabled entirely.

Topics

#Virtual Warehouse#Auto suspend#Default settings#Cost management

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice