Answer-first summary for fast verification
Answer: Use the ALTER WAREHOUSE command on a suspended Standard virtual warehouse.
According to Snowflake documentation and the community discussion consensus, the ALTER WAREHOUSE command to change warehouse types (from Standard to Snowpark-optimized) can only be executed when the warehouse is in a SUSPENDED state. The community discussion shows 100% agreement on option C, with multiple users confirming that the warehouse must be suspended for this operation. Option A and B are incorrect because they involve active warehouses, which cannot be altered for type changes. Option D is incorrect because it specifies a Snowpark-optimized warehouse, but the question asks about converting FROM a Standard warehouse TO a Snowpark-optimized warehouse.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can a user convert an existing Standard virtual warehouse to a Snowpark-optimized virtual warehouse using Snowsight?
A
Use the ALTER WAREHOUSE command on an active Standard virtual warehouse.
B
Use the ALTER WAREHOUSE command on an active Snowpark-optimized warehouse.
C
Use the ALTER WAREHOUSE command on a suspended Standard virtual warehouse.
D
Use the ALTER WAREHOUSE command on a suspended Snowpark-optimized warehouse.
No comments yet.