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.
reachbharathan
3 weeks agotharangaweer
2 months agoMallikharjuna452
8 months, 2 weeks agoVivek121
11 months agoAnireddySaikiranReddy
1 year, 1 month ago_yyukta
1 year, 1 month agoKHarish
1 year, 3 months agoVS3497
1 year, 9 months agoinstride
1 year, 10 months agoMayuri917233
1 year, 10 months agorajivgupta780
2 years, 2 months agoTapasgup007
2 years, 4 months agoPercy2112
2 years, 7 months agoLuciBhish
3 years, 1 month agoSundarr
3 years, 2 months ago