Answer-first summary for fast verification
Answer: SnowSQL supports both a configuration file and a command line option for specifying a default warehouse., The default virtual warehouse size can be changed at any time.
The question asks to select two characteristics of Snowflake virtual warehouses. Based on the community discussion and Snowflake documentation: Option C is correct because SnowSQL supports both configuration files and command-line options for specifying a default warehouse, as confirmed by multiple users and documentation. Option E is correct because the default virtual warehouse size can be changed at any time, which is a standard feature in Snowflake. Option A is incorrect because auto-resume applies to the entire warehouse, not just the last cluster in a multi-cluster setup. Option B is incorrect because auto-suspend is available in all editions, though multi-cluster auto-suspend requires Enterprise edition. Option D is incorrect because the ODBC driver allows specifying a default warehouse through connection parameters. The community consensus strongly supports C and E, with the highest upvoted comment (30 upvotes) explicitly stating 'CE are correct' and detailed reasoning provided in other comments.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which of the following are characteristics of Snowflake virtual warehouses? (Select two.)
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.
No comments yet.