New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake COF-R02 Exam - 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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Paulene
3 months ago
Wait, are we sure A is the one? I thought it was something else!
upvoted 0 times
...
Wayne
3 months ago
D? Really? That doesn’t seem right at all.
upvoted 0 times
...
Edna
4 months ago
C sounds familiar, but not sure it’s correct.
upvoted 0 times
...
Loise
4 months ago
I think B is more accurate, though.
upvoted 0 times
...
Carlota
4 months ago
A is definitely the right choice!
upvoted 0 times
...
Eun
4 months ago
I remember "SHOW GRANTS TO" being used for users, so I think B is probably not the right choice here.
upvoted 0 times
...
Hobert
4 months ago
I’m leaning towards D because it sounds like it’s asking for the grants specifically on that role, but I could be mixing it up with another command.
upvoted 0 times
...
Lourdes
5 months ago
I feel like I practiced a question similar to this, and it was definitely about showing grants, but I can't recall if it was "of" or "to."
upvoted 0 times
...
Ellsworth
5 months ago
I think it might be A, but I’m not completely sure. I remember something about grants being related to roles.
upvoted 0 times
...
Carri
5 months ago
Ah, I remember learning about the Infor JDBC connector in one of the lectures. I'm pretty confident I can get this one right.
upvoted 0 times
...
Chantell
5 months ago
Okay, I think I've got a good grasp on the steps here. First, I'll create the prevent-privileged-policy PSP, then the psp-sa ServiceAccount, the prevent-role ClusterRole, and finally the prevent-role-binding ClusterRoleBinding. Gotta make sure I don't miss any of those.
upvoted 0 times
...
Erinn
5 months ago
Okay, let me break this down step-by-step. The key things I need to focus on are the income limitation, the qualified expenses, and how scholarships factor in. I think I can work through this.
upvoted 0 times
...
Davida
5 months ago
I'm pretty sure the Charpy impact test is used to determine a material's toughness, so I'll go with option A.
upvoted 0 times
...
Marcos
5 months ago
This question seems tricky, but I think I can figure it out. I'll need to carefully consider the HSRP and OTV configuration to determine the best way to optimize the traffic.
upvoted 0 times
...
Jin
10 months ago
Aha! Option C is definitely the way to go. Snowflake makes it pretty straightforward to manage role permissions.
upvoted 0 times
...
Elvis
10 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
10 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
8 months ago
Let me check the Snowflake documentation to confirm
upvoted 0 times
...
Ricki
9 months ago
I believe it's SHOW GRANTS FOR ROLE MY_ROLE
upvoted 0 times
...
Cristen
9 months ago
I think it might be SHOW GRANTS TO ROLE MY_ROLE
upvoted 0 times
...
...
Dana
10 months ago
I think option C is the correct answer, as the SHOW GRANTS FOR ROLE statement is used to display the grants made on a specific role.
upvoted 0 times
Adelle
9 months ago
I believe it is option D, SHOW GRANTS ON ROLE MY_ROLE.
upvoted 0 times
...
Isaac
9 months ago
I think it might be option B, SHOW GRANTS TO ROLE MY_ROLE.
upvoted 0 times
...
Alex
9 months ago
I agree, option C seems like the right choice.
upvoted 0 times
...
...
Cristy
10 months ago
I'm not sure, but I think D) SHOW GRANTS ON ROLE MY_ROLE could also be a valid option.
upvoted 0 times
...
Doug
11 months ago
I agree with Ashton, because the statement 'FOR ROLE' makes sense in this context.
upvoted 0 times
...
Ashton
11 months ago
I think the answer is C) SHOW GRANTS FOR ROLE MY_ROLE.
upvoted 0 times
...

Save Cancel