Deal of The Day! 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-C03 Exam - Topic 2 Question 3 Discussion

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.Which command will show all privileges granted to that schema?
B) SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING
A) SHOW GRANTS ON ROLE DATA_SCIENCE
C) SHOW GRANTS TO USER INQUISITIVE_PERSON
D) SHOW GRANTS OF ROLE DATA_SCIENCE

Snowflake COF-C03 Exam - Topic 2 Question 3 Discussion

Actual exam question for Snowflake's COF-C03 exam
Question #: 3
Topic #: 2
[All COF-C03 Questions]

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.

Which command will show all privileges granted to that schema?

Show Suggested Answer Hide Answer
Suggested Answer: B

To showall privileges granted to a specific schema, the commandSHOW GRANTS ON SCHEMA <schema_name>should beused3. In this case, it would beSHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING. Reference: [COF-C03] SnowPro Core Certification Exam Study Guide


by Stefany at Jul 02, 2026, 12:25 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Salina
2 days ago
C is irrelevant here.
upvoted 0 times
...
Stephaine
7 days ago
I agree with B. It’s the most direct.
upvoted 0 times
...
Jolanda
12 days ago
A seems off. It’s for roles, not schemas.
upvoted 0 times
...
Myra
17 days ago
Yes, but it shows all grants for that role.
upvoted 0 times
...
Viola
22 days ago
D? Isn't that just for the role?
upvoted 0 times
...
Myra
27 days ago
I prefer D.
upvoted 0 times
...
Elizabeth
1 month ago
It shows grants on the specific schema.
upvoted 0 times
...
Viola
1 month ago
Why B?
upvoted 0 times
...
Elizabeth
1 month ago
I think it's B.
upvoted 0 times
...
Nohemi
2 months ago
I disagree, I thought it was A at first.
upvoted 0 times
...
Deangelo
2 months ago
Definitely B! It’s straightforward.
upvoted 0 times
...
Filiberto
2 months ago
Wait, can you really show grants on a schema like that?
upvoted 0 times
...
Alisha
2 months ago
I think D might be correct too.
upvoted 0 times
...
Roslyn
2 months ago
B is the right choice!
upvoted 0 times
...
Jospeh
2 months ago
I vaguely recall that SHOW GRANTS ON SCHEMA is the way to go for checking privileges. So, B seems like the best choice to me.
upvoted 0 times
...
Lavina
3 months ago
I thought we were supposed to use the SHOW GRANTS command, but I can't remember if it was for the role or the schema. This is tricky!
upvoted 0 times
...
Lai
3 months ago
I'm not entirely sure, but I feel like option D could be relevant since it mentions the role directly. We practiced something similar in class.
upvoted 0 times
...
Major
3 months ago
I think the command we need is related to the schema, so maybe it's B? I remember something about showing grants on specific objects.
upvoted 0 times
...

Save Cancel