Snowflake Exam COF-R02 Topic 1 Question 17 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 17
Topic #: 1

[All COF-R02 Questions]

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

ASHOW GRANTS OF ROLE MY_ROLE

BSHOW GRANTS TO ROLE MY_ROLE

CSHOW GRANTS FOR ROLE MY_ROLE

DSHOW GRANTS ON ROLE MY_ROLE

Show Suggested Answer

Suggested Answer: A

by Ezekiel at Aug 06, 2023, 08:53 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

27 days ago

Aha! Option C is definitely the way to go. Snowflake makes it pretty straightforward to manage role permissions.

upvoted 0 times

...

28 days ago

Wait, is this a trick question? I mean, how can I determine who has access to a role if I can't even access the role itself? *laughs*

upvoted 0 times

...

29 days ago

Option B looks promising, but I'm not sure if it's the exact syntax. I'll double-check the Snowflake documentation to be sure.

upvoted 0 times

14 hours ago

I think it might be SHOW GRANTS TO ROLE MY_ROLE

upvoted 0 times

...

2 months ago

I think the answer is C) SHOW GRANTS FOR ROLE MY_ROLE.

upvoted 0 times

...