Which statement about a Snowflake session and current warehouses is true?

• A. A session can have multiple current warehouses at the same time.
• B. A session can have only one current warehouse at a time.
• C. A session cannot select a current warehouse.
• D. A session's current warehouse is dynamic.

Answer: (B)

Snowflake keeps a single current warehouse for each session. All queries you run in that session use that warehouse by default. You switch to a different warehouse during the session with the USE WAREHOUSE command, which changes the one active warehouse for that session. Because only one warehouse can be current at any moment, a session cannot have multiple current warehouses at the same time. You can change which warehouse is current, but at any given moment there is exactly one.