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.
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."
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Deepika_s
2 months, 2 weeks agojeny12138
2 months, 3 weeks agojeny12138
2 months, 3 weeks agoreachbharathan
3 months, 3 weeks agotharangaweer
5 months agoMallikharjuna452
11 months, 2 weeks agoVivek121
1 year, 1 month agoAnireddySaikiranReddy
1 year, 4 months ago_yyukta
1 year, 4 months agoKHarish
1 year, 6 months agoVS3497
2 years agoinstride
2 years agoMayuri917233
2 years, 1 month agorajivgupta780
2 years, 5 months agoTapasgup007
2 years, 7 months agoPercy2112
2 years, 10 months agoLuciBhish
3 years, 4 months ago