SnowPro Core Certification — Question 136

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

Answer options

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

Correct answer: C

Explanation

Option C is correct because SnowSQL indeed supports specifying a default warehouse through both a configuration file and command line options. Options A, B, D, and E are incorrect as they misrepresent the capabilities of Snowflake virtual warehouses regarding auto-resume, auto-suspend availability, default warehouse settings with ODBC, and changing warehouse size.