Valid COF-C03 Dumps shared by ExamDiscuss.com for Helping Passing COF-C03 Exam! ExamDiscuss.com now offer the newest COF-C03 exam dumps, the ExamDiscuss.com COF-C03 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com COF-C03 dumps with Test Engine here:
An engineer has a connection named dev_project in the Snowflake CLI config.toml file. The connection specifies a role other than SYSADMIN. The engineer then runs: snow sql -c dev_project When the engineer executes: SELECT CURRENT_ROLE(); the query returns SYSADMIN. Why did Snowflake CLI use the SYSADMIN role?
Correct Answer: C
Snowflake CLI can obtain connection parameters from multiple sources. When the same connection parameter is specified in more than one place, the higher-precedence source overrides the lower-precedence source. An environment variable such as SNOWFLAKE_ROLE overrides the role configured for the connection in config.toml. Therefore, when SNOWFLAKE_ROLE=SYSADMIN is present, the CLI session uses SYSADMIN, even when the selected connection specifies another role. A missing warehouse does not cause Snowflake CLI to ignore the configured role. A user's default role can also be overridden when another valid role is explicitly supplied through a higher-precedence configuration source. References: Snowflake Documentation - Configuring connections for Snowflake CLI: https://docs.snowflake.com/en /developer-guide/snowflake-cli/connecting/configure-connections Snowflake Documentation - Connecting to Snowflake with Snowflake CLI: https://docs.snowflake.com/en /developer-guide/snowflake-cli/connecting/connect ==