SnowPro Core Certification — Question 71

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

Answer options

• A. COPY WAREHOUSE FROM <<config file>>;
• B. SET WAREHOUSE = <<warehouse name>>;
• C. USE WAREHOUSE <<warehouse name>>;
• D. USE VIRTUAL_WAREHOUSE <<warehouse name>>;

Correct answer: C

Explanation

The correct answer is C, as 'USE WAREHOUSE' directly specifies which Virtual Warehouse to activate for the session. Options A and B do not properly set the Virtual Warehouse, and D, while similar, uses incorrect syntax as the correct command does not require the 'VIRTUAL_' prefix.