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
Nohemi
2 days ago
I disagree, I thought it was A at first.
upvoted 0 times
...
Deangelo
7 days ago
Definitely B! It’s straightforward.
upvoted 0 times
...
Filiberto
13 days ago
Wait, can you really show grants on a schema like that?
upvoted 0 times
...
Alisha
18 days ago
I think D might be correct too.
upvoted 0 times
...
Roslyn
23 days ago
B is the right choice!
upvoted 0 times
...
Jospeh
28 days 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
1 month 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
1 month 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
1 month 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