Which command sets the Virtual Warehouse for a session?

The correct answer is C. USE WAREHOUSE <<warehouse name>>. In Snowflake, the correct SQL command to set or switch the active virtual warehouse for the current session is USE WAREHOUSE <warehouse_name>;. This is standard Snowflake syntax. Option B (SET WAREHOUSE) is not valid Snowflake SQL syntax. Option D (USE VIRTUAL_WAREHOUSE) is…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

ACOPY WAREHOUSE FROM <<config file>>;
BSET WAREHOUSE = <<warehouse name>>;
CUSE WAREHOUSE <<warehouse name>>;
DUSE VIRTUAL_WAREHOUSE <<warehouse name>>;

How the community answered

(38 responses)

A
5% (2)
C
92% (35)
D
3% (1)

Explanation

In Snowflake, the correct SQL command to set or switch the active virtual warehouse for the current session is USE WAREHOUSE <warehouse_name>;. This is standard Snowflake syntax. Option B (SET WAREHOUSE) is not valid Snowflake SQL syntax. Option D (USE VIRTUAL_WAREHOUSE) is incorrect because the keyword is simply WAREHOUSE, not VIRTUAL_WAREHOUSE. Option A is entirely fabricated syntax and does not exist in Snowflake.

Topics

#Virtual Warehouses#SQL Commands#Session Context

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice