Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake COF-C02 Exam - Topic 5 Question 66 Discussion

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
B) SHOW GRANTS TO ROLE MY_ROLE
A) SHOW GRANTS OF ROLE MY_ROLE
C) SHOW GRANTS FOR ROLE MY_ROLE
D) SHOW GRANTS ON ROLE MY_ROLE

Snowflake COF-C02 Exam - Topic 5 Question 66 Discussion

Actual exam question for Snowflake's COF-C02 exam
Question #: 66
Topic #: 5
[All COF-C02 Questions]

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

Show Suggested Answer Hide Answer
Suggested Answer: B

The SQL statementSHOW GRANTS TO ROLE MY_ROLEis used to determine which users and roles have access to a role called MY_ROLE. This statement lists all the privileges granted to the role, including which roles and users can assume MY_ROLE.References:[COF-C02] SnowPro Core Certification Exam Study Guide


by Stanford at Mar 07, 2026, 04:59 PM

Limited Time Offer

25%

Off

Get Premium COF-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Veronika
23 days ago
I always mix these up, but A sounds right.
upvoted 0 times
...
Gail
28 days ago
Wait, are you sure? I thought it was B.
upvoted 0 times
...
Lemuel
1 month ago
Totally agree, that's the right one!
upvoted 0 times
...
Tomoko
1 month ago
It's A) SHOW GRANTS OF ROLE MY_ROLE.
upvoted 0 times
...
Alishia
1 month ago
I’m leaning towards C) SHOW GRANTS FOR ROLE MY_ROLE, but I’m not confident. This is tricky!
upvoted 0 times
...
Jose
2 months ago
I feel like B) SHOW GRANTS TO ROLE MY_ROLE could be the answer, but I might be mixing it up with another command.
upvoted 0 times
...
Maybelle
2 months ago
I remember practicing a question similar to this, and I think it was about grants too. Maybe it’s D) SHOW GRANTS ON ROLE MY_ROLE?
upvoted 0 times
...
Jerry
2 months ago
I think it's A) SHOW GRANTS OF ROLE MY_ROLE, but I’m not completely sure if that’s the right syntax.
upvoted 0 times
...
Kristine
2 months ago
I thought it was C) SHOW GRANTS FOR ROLE MY_ROLE, but that doesn't sound quite right now that I think about it.
upvoted 0 times
...
Alberto
2 months ago
I feel like it could be D) SHOW GRANTS ON ROLE MY_ROLE, but I can't recall if "ON" is the correct keyword for this context.
upvoted 0 times
...
Lindsey
2 months ago
I remember practicing a similar question, and I think it was about showing grants to a user, which might be B) SHOW GRANTS TO ROLE MY_ROLE.
upvoted 0 times
...
Jill
3 months ago
I think it's A) SHOW GRANTS OF ROLE MY_ROLE, but I'm not entirely sure if that's the right syntax.
upvoted 0 times
...

Save Cancel