Which of the following commands sets the Virtual Warehouse for a session?
Which of the following commands sets the Virtual Warehouse for a session?
To set the Virtual Warehouse for a session in Snowflake, the correct command is 'USE WAREHOUSE <<warehouse name>>;'. This command specifies or changes the current warehouse for a session. The other options do not follow the correct syntax or functionality for setting a Virtual Warehouse in Snowflake.
Answer is C. Example : use warehouse compute_wh;
USE WAREHOUSE <VWH>;
C is correct
The correct answer is C. According to snowflake docs, "A Snowflake session can only have one current warehouse at a time. The current warehouse for a session can be specified or changed at any time through the USE WAREHOUSE command."
Why NOT B?
Use Warehouse command.
C is correct
C is correct
C. USE WAREHOUSE <<warehouse name>>;
USE WAREHOUSE <<warehouse name>> . C is correct
C.USE WAREHOUSE <<warehouse name>> . C is correct
C. USE WAREHOUSE <<warehouse name>>;
C. USE WAREHOUSE <<warehouse name>>;
c.use warehouse <warehouse name>
Both USE WAREHOUSE and SET WAREHOUSE commands serve the same purpose - they switch the current session to use the specified warehouse. They are completely interchangeable and functionally identical. The only difference is syntactic preference, similar to how both USE SCHEMA and SET SCHEMA are equivalent commands. Example usage: USE WAREHOUSE compute_wh SET WAREHOUSE compute_wh Choose whichever syntax you prefer - they will produce the same result.
D or C
c is correct
Although, USE WAREHOUSE and SET WAREHOUSE commands serve the same purpose -w.r.t. SNOWFLAKE we use USE WAREHOUSE command, so Ans is C.