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
Get Premium COF-C03 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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
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.