Which of the following statements will you use to change the warehouse for workload processing to a warehouse named 'COMPUTE_WH_XL'?

A)  SET CURRENT_WAREHOUSE = COMPUTE_WH_XL
B)  USE WAREHOUSE COMPUTE_WH_XL;
C)  USE CURRENT_WAREHOUSE(‘COMPUTE_WH_XL’);
D)  SET CURRENT_WAREHOUSE = COMPUTE_WH, SIZE = XL;

Correct Answer :   USE WAREHOUSE COMPUTE_WH_XL;


Explanation :

A session context in Snowflake consists of 4 objects:
 
* Role
* Warehouse  
* Database
* Schema

You can set appropriate session context using a set of SQL statements given below. These statements specify the role, warehouse, database, or schema to use for the current session:
 
You can set appropriate session context using a set of SQL statements given below. These statements specify the role, warehouse, database, or schema to use for the current session:

Use warehouse <<warehouse-name>>
Use role <<role-name>>
Use database <<database-name>>
Use schema <<schema-name>>
So the correct answer of this question is:
Use warehouse COMPUTE_WH_XL;