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

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
Jose
3 days 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
9 days 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
14 days 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
19 days 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
24 days 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
29 days 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
1 month 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