SnowPro Core Certification — Question 1255

Which default warehouse configuration has the highest precedence whenever a new session is created by a user?

Answer options

• 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

Correct answer: C

Explanation

The default warehouse specified on a CLI or in drivers/connectors parameters has the highest precedence because it is explicitly set at the connection level, overriding other configurations. The other options, while valid, are secondary and will be ignored if a CLI specification is present. This ensures that the most direct instruction for the session is followed.