Exam COF-C03 Topic 1 Question 13 Discussion

Actual exam question for Snowflake's COF-C03 exam
Question #: 13
Topic #: 1
Which SQL command can be used to verify the privileges that are granted to a role?

Suggested Answer: C Vote an answer

To verify the privileges that have been granted to a specific role in Snowflake, the correct SQL command is SHOW GRANTS TO ROLE <Role Name>. This command lists all the privileges granted to the specified role, including access to schemas, tables, and other database objects. This is a useful command for administrators and users with sufficient privileges to audit and manage role permissions within the Snowflake environment.
References:
Snowflake Documentation: SHOW GRANTS

by Victor at Sep 10, 2026, 08:20 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
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