Snowflake ADA-C01 Exam - 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

Berry

3 months ago

D seems too restrictive. Why would we want that?

upvoted 0 times

...

Launa

3 months ago

C sounds interesting, but is it really practical?

upvoted 0 times

...

Rupert

3 months ago

Wait, what? I thought schema privileges were more important.

upvoted 0 times

...

Luisa

4 months ago

Totally agree with A! Makes the most sense.

upvoted 0 times

...

Mirta

4 months ago

I think A is correct. Database privileges usually win.

upvoted 0 times

...

Valentin

4 months ago

I’m leaning towards D because I think restrictive policies are often favored in access control, but I need to double-check my notes on that.

upvoted 0 times

...

Ciara

4 months ago

I feel like the answer might be C, where both policies are combined, but I can't recall if it’s the most permissive or restrictive that takes precedence.

upvoted 0 times

...

Leonor

4 months ago

I think I saw a practice question where schema privileges were mentioned as having priority in certain contexts. Could that be relevant here?

upvoted 0 times

...

Lovetta

5 months ago

I remember something about database privileges being more powerful, but I'm not entirely sure if they always take precedence over schema privileges.

upvoted 0 times

...

Suzan

5 months ago

I've got a good feeling about this question. The answer is C - an access policy combining both the database object and the schema object, with the most permissive policy taking precedence.

upvoted 0 times

...

Augustine

5 months ago

I'm not entirely sure about this one. I'll need to weigh the pros and cons of each option to determine the best access control policy.

upvoted 0 times

...

Lyndia

5 months ago

Okay, I think I know the answer to this. The key is understanding how the most permissive policy takes precedence when there are overlapping privileges.

upvoted 0 times

...

Xochitl

5 months ago

Hmm, I'm a bit confused on this one. I'll need to review my notes on access control policies to figure out the right approach.

upvoted 0 times

...

Johnathon

5 months ago

This seems like a tricky question. I'll need to think carefully about how database and schema privileges interact.

upvoted 0 times

...

Cristen

5 months ago

Hmm, this seems straightforward. I think the umask command would be the best option to set the default permissions for new files.

upvoted 0 times

...

Theola

5 months ago

I've seen "Paypal-pay" used in more dynamic settings, so I doubt that's right for a stable ticket booking service.

upvoted 0 times

...

Chi

2 years ago

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

upvoted 0 times

...

Jennifer

2 years 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

2 years ago

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

upvoted 0 times

...

Chi

2 years ago

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

upvoted 0 times

...

Jennifer

2 years ago

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

upvoted 0 times

...

Chi

2 years ago

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

upvoted 0 times

...

Chauncey

2 years 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

2 years 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

2 years 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

2 years 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

2 years 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

...