Answer-first summary for fast verification
Answer: Default warehouse specified on a CLI or in drivers/connectors parameters
According to Snowflake documentation and the community discussion, the precedence order for default warehouse configuration is: 1) Default warehouse specified on CLI or in drivers/connectors parameters (highest precedence), 2) Default warehouse in the configuration file of client utilities, 3) Default warehouse for the user, 4) Default warehouse of the role assigned to the user. Option C represents the highest level of precedence as it allows explicit specification at connection time, overriding all other default settings. The community discussion with 100% consensus and upvoted comments confirms this understanding, referencing the official Snowflake documentation on warehouse precedence.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which default warehouse configuration takes precedence when a new user session is created?
A
Default warehouse for the user
B
Default warehouse in the configuration file of the client utilities
C
Default warehouse specified on a CLI or in drivers/connectors parameters
D
Default warehouse of the role assigned to the user
No comments yet.