Exam COF-C03 Topic 1 Question 963 Discussion

Actual exam question for Snowflake's COF-C03 exam
Question #: 963
Topic #: 1
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?

Suggested Answer: C Vote an answer

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
==

by queen at Aug 06, 2026, 02:13 AM

Limited Time Offer

15%

Off

Get Premium COF-C03 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
queen
2026-08-06 02:13:54
Selected Answer: C
CLI argument > Environment variable > config.toml
upvoted 1 times
...
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10