Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

Question

Options

• AAuto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
• BThe ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
• CSnowSQL supports both a configuration file and a command line option for specifying a default
• DA user cannot specify a default warehouse when using the ODBC driver.
• EThe default virtual warehouse size can be changed at any time.

• A
  3% (1)
• B
  5% (2)
• C
  89% (34)
• D
  3% (1)

Explanation

C is correct: SnowSQL (the Snowflake CLI client) supports specifying a default warehouse both via its configuration file (~/.snowsql/config) and via a command-line option (--warehouse), giving users flexibility. E is correct: The default virtual warehouse size assigned to a user or in a connection can be changed at any time without any restrictions. A is incorrect: Auto-resume applies to any suspended warehouse in a multi-cluster setup, not just the last one started. B is incorrect: Auto-suspend is available in all Snowflake editions, including Standard. D is incorrect: Users can specify a default warehouse when using the ODBC driver via the connection string parameters.

No community discussion yet for this question.