
Answer-first summary for fast verification
Answer: USE WAREHOUSE <<warehouse name>>;
The correct answer is C because the USE WAREHOUSE command is the standard and recommended way to set the current virtual warehouse for a session in Snowflake. While option B (SET WAREHOUSE) is functionally equivalent and can also change the session's warehouse, the USE WAREHOUSE syntax is more commonly used and explicitly mentioned in Snowflake documentation as the command for this purpose. Option A is incorrect as COPY WAREHOUSE is not a valid Snowflake command for setting session context. Option D is incorrect because VIRTUAL_WAREHOUSE is not valid syntax; warehouses in Snowflake are referred to simply as 'WAREHOUSE'. The community discussion shows strong consensus for C (88% of answers), with several comments citing Snowflake documentation that specifically recommends USE WAREHOUSE for this purpose.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.