Snowflake Exam ADA-C01 Topic 7 Question 10 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 10
Topic #: 7

What access control policy will be put into place when future grants are assigned to both database and schema objects?

ADatabase privileges will take precedence over schema privileges.

BSchema privileges will take precedence over database privileges.

CAn access policy combining both the database object and the schema object will be used, with the most permissive policy taking precedence.

DAn access policy combining both the database object and the schema object will be used, with the most restrictive policy taking precedence.

Show Suggested Answer

Suggested Answer: B

When future grants are defined on the same object type for a database and a schema in the same database, the schema-level grants take precedence over the database level grants, and the database level grants are ignored4. This behavior applies to privileges on future objects granted to one role or different roles4. Future grants allow defining an initial set of privileges to grant on new (i.e. future) objects of a certain type in a database or a schema3. As soon as the new objects are created inside the database or schema, the predefined set of privileges are assigned to the object automatically without any manual intervention3.

by Paris at Apr 11, 2024, 01:52 PM

Limited Time Offer

25%

Off

Get Premium ADA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Jennifer

1 days ago

I agree. It's important to understand how access control policies work in this scenario.

upvoted 0 times

...

Chi

2 days ago

I think we should consider how database and schema privileges are assigned.

upvoted 0 times

...

Chauncey

24 days ago

Seriously, who comes up with these exam questions? They're like something straight out of a cyberpunk novel. I'm just going to close my eyes and pick an answer at random. *shrugs*

upvoted 0 times

...

Norah

26 days ago

This question is giving me flashbacks to that time I tried to hack into the school's database. Good times, good times. Anyway, I think I'm going with option A. Database privileges just sound more important, you know?

upvoted 0 times

...

Johnetta

27 days ago

Hmm, I don't know. I feel like the answer might be B, where the schema privileges take precedence. That just seems more logical to me, but I could be totally off.

upvoted 0 times

...

Mitzie

28 days ago

I'm pretty sure the answer is D. I mean, who wants to deal with the most restrictive policy, right? That just sounds like a recipe for a headache.

upvoted 0 times

...

Glen

1 months ago

Yeah, this one's a real head-scratcher. I'm leaning towards option C, since it sounds like it would combine the policies and go with the more permissive one. But I could be way off base here.

upvoted 0 times

...

Audra

1 months ago

Whoa, this question looks tricky! I'm not sure if I should go with database privileges or schema privileges. What do you all think?

upvoted 0 times

...