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

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

Contribute your Thoughts:

Submit Cancel

Jin

3 months ago

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

upvoted 0 times

...

Elvis

3 months 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

...

Tomoko

3 months 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

Mose

2 months ago

Let me check the Snowflake documentation to confirm

upvoted 0 times

...

Ricki

2 months ago

I believe it's SHOW GRANTS FOR ROLE MY_ROLE

upvoted 0 times

...

Cristen

2 months ago

I think it might be SHOW GRANTS TO ROLE MY_ROLE

upvoted 0 times

...

4 months ago

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

upvoted 0 times

...