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

Chi

5 months ago

That makes sense. It's important to have a clear access control policy in place.

upvoted 0 times

...

Jennifer

5 months ago

I think a combination of both database and schema policies would be best, with the most permissive policy taking precedence.

upvoted 0 times

...

Jacki

5 months ago

I believe schema privileges should take precedence because they are more specific to the objects.

upvoted 0 times

...

Chi

6 months ago

Do you think database privileges should take precedence over schema privileges?

upvoted 0 times

...

Jennifer

6 months ago

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

upvoted 0 times

...

Chi

7 months ago

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

upvoted 0 times

...

Chauncey

7 months 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

7 months 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

7 months 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

7 months 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

7 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

...