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

Snowflake COF-C03 Exam - Topic 2 Question 3 Discussion

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

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?

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


Get Premium COF-C03 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test
27 comments · newest first
HA
Halina 14 hours ago
Yeah, B is straightforward. No confusion there.
EM
Emiko 6 days ago
I feel B is the best choice. Less ambiguity.
AR
Art 11 days ago
D is good, but B is more precise for the schema.
YU
Yuriko 16 days ago
But what about D? It shows grants of the role too.
LU
Lucina 21 days ago
I agree, B makes sense. Clear and specific.
AN
Annabelle 26 days ago
I think it's B. It directly targets the schema.
MY
Myra 1 month ago
D could work too, but B is clearer.
EL
Elizabeth 1 month ago
B gives the complete picture.
ST
Stephaine 1 month ago
Exactly, we need schema privileges.
SA
Salina 2 months ago
C is irrelevant here.
ST
Stephaine 2 months ago
I agree with B. It’s the most direct.
JO
Jolanda 2 months ago
A seems off. It’s for roles, not schemas.
MY
Myra 2 months ago
Yes, but it shows all grants for that role.
VI
Viola 2 months ago
D? Isn't that just for the role?
MY
Myra 2 months ago
I prefer D.
EL
Elizabeth 3 months ago
It shows grants on the specific schema.
VI
Viola 3 months ago
Why B?
EL
Elizabeth 3 months ago
I think it's B.
NO
Nohemi 3 months ago
I disagree, I thought it was A at first.
DE
Deangelo 3 months ago
Definitely B! It’s straightforward.
FI
Filiberto 3 months ago
Wait, can you really show grants on a schema like that?
AL
Alisha 4 months ago
I think D might be correct too.
RO
Roslyn 4 months ago
B is the right choice!
JO
Jospeh 4 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.
LA
Lavina 4 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!
LA
Lai 4 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.
MA
Major 4 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.
0/2000 characters

Save Cancel