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?

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: 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:

Submit Cancel

Desirae

1 day ago

I feel like it's B. Grants to a role make sense.

upvoted 0 times

...

Dong

6 days ago

I think it's A. Seems straightforward.

upvoted 0 times

...

Sue

11 days ago

Wait, is it really A? I thought there were other options too!

upvoted 0 times

...

Charlene

17 days ago

I agree with A, that's the standard way to check grants.

upvoted 0 times

...

Malinda

22 days ago

A seems right, but why not C?

upvoted 0 times

...

Barrett

27 days ago

I thought it was B) SHOW GRANTS TO ROLE MY_ROLE.

upvoted 0 times

...

Glendora

1 month ago

It's definitely A) SHOW GRANTS OF ROLE MY_ROLE.

upvoted 0 times

...

Dominic

1 month ago

I thought there were more options for this.

upvoted 0 times

...

Julianna

1 month ago

No way, it's definitely A.

upvoted 0 times

...

Gertude

2 months ago

Wait, are you sure? I thought it was B.

upvoted 0 times

...

Ahmed

2 months ago

Totally agree, that's the right one!

upvoted 0 times

...

Lashawnda

2 months ago

It's A) SHOW GRANTS OF ROLE MY_ROLE.

upvoted 0 times

...

Colby

2 months ago

I thought it was C, but now I'm doubting myself!

upvoted 0 times

...

Veronika

4 months ago

I always mix these up, but A sounds right.

upvoted 0 times

...

Gail

4 months ago

Wait, are you sure? I thought it was B.

upvoted 0 times

...

Lemuel

4 months ago

Totally agree, that's the right one!

upvoted 0 times

...

Tomoko

4 months ago

It's A) SHOW GRANTS OF ROLE MY_ROLE.

upvoted 0 times

...

Alishia

4 months ago

I’m leaning towards C) SHOW GRANTS FOR ROLE MY_ROLE, but I’m not confident. This is tricky!

upvoted 0 times

...

Jose

4 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

5 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

5 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

5 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

5 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

5 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

6 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

...