MENU
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
Suggested Answer: B
Get Premium COF-C02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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
33 comments · newest first
RE
Ressie
5 days ago
I feel like it's B. Grants to a role make sense.
EM
Emmanuel
10 days ago
I think it's A. Seems straightforward.
CL
Clay
15 days ago
I believe it's D) SHOW GRANTS ON ROLE MY_ROLE. It specifies the role clearly.
DE
Deane
20 days ago
I'm leaning towards C) SHOW GRANTS FOR ROLE MY_ROLE. It sounds right to me.
CH
Chery
26 days ago
I feel like it could be B) SHOW GRANTS TO ROLE MY_ROLE. It makes sense for access.
HE
Herman
1 month ago
I think it's A) SHOW GRANTS OF ROLE MY_ROLE. Seems straightforward.
KY
Kyoko
1 month ago
D is confusing. Why "on"?
LE
Lenny
1 month ago
C sounds right. Grants for a role?
DE
Desirae
2 months ago
I feel like it's B. Grants to a role make sense.
DO
Dong
2 months ago
I think it's A. Seems straightforward.
SU
Sue
2 months ago
Wait, is it really A? I thought there were other options too!
CH
Charlene
2 months ago
I agree with A, that's the standard way to check grants.
MA
Malinda
2 months ago
A seems right, but why not C?
BA
Barrett
2 months ago
I thought it was B) SHOW GRANTS TO ROLE MY_ROLE.
GL
Glendora
3 months ago
It's definitely A) SHOW GRANTS OF ROLE MY_ROLE.
DO
Dominic
3 months ago
I thought there were more options for this.
JU
Julianna
3 months ago
No way, it's definitely A.
GE
Gertude
3 months ago
Wait, are you sure? I thought it was B.
AH
Ahmed
3 months ago
Totally agree, that's the right one!
LA
Lashawnda
3 months ago
It's A) SHOW GRANTS OF ROLE MY_ROLE.
CO
Colby
4 months ago
I thought it was C, but now I'm doubting myself!
VE
Veronika
5 months ago
I always mix these up, but A sounds right.
GA
Gail
5 months ago
Wait, are you sure? I thought it was B.
LE
Lemuel
5 months ago
Totally agree, that's the right one!
TO
Tomoko
6 months ago
It's A) SHOW GRANTS OF ROLE MY_ROLE.
AL
Alishia
6 months ago
I’m leaning towards C) SHOW GRANTS FOR ROLE MY_ROLE, but I’m not confident. This is tricky!
JO
Jose
6 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.
MA
Maybelle
6 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?
JE
Jerry
6 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.
KR
Kristine
6 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.
AL
Alberto
7 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.
LI
Lindsey
7 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.
JI
Jill
7 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.