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

2 days ago

I'm not sure, but I think D) SHOW GRANTS ON ROLE MY_ROLE could also be a valid option.

upvoted 0 times

...

4 days ago

I agree with Ashton, because the statement 'FOR ROLE' makes sense in this context.

upvoted 0 times

...

12 days ago

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

upvoted 0 times

...