Exam SnowPro Core All QuestionsBrowse all questions from this exam
Go to Exam
Question 12

Which of the following commands sets the Virtual Warehouse for a session?

    Correct Answer: C

    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.

Discussion
LuciBhishOption: C

USE WAREHOUSE <VWH>;

SundarrOption: C

Answer is C. Example : use warehouse compute_wh;

instrideOption: C

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."

rajivgupta780Option: C

C is correct

Mallikharjuna452Option: C

C. USE WAREHOUSE <<warehouse name>>;

Vivek121Option: B

Why NOT B?

AnireddySaikiranReddyOption: C

C. USE WAREHOUSE <<warehouse name>>;

_yyuktaOption: C

C.USE WAREHOUSE <<warehouse name>> . C is correct

KHarishOption: C

USE WAREHOUSE <<warehouse name>> . C is correct

VS3497Option: C

C. USE WAREHOUSE <<warehouse name>>;

Mayuri917233Option: C

C is correct

Tapasgup007Option: C

C is correct

Percy2112Option: C

Use Warehouse command.