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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake Exam DEA-C01 Topic 5 Question 39 Discussion

Actual exam question for Snowflake's DEA-C01 exam
Question #: 39
Topic #: 5
[All DEA-C01 Questions]

A Data Engineer wants to centralize grant management to maximize security. A user needs ownership on a table m a new schema However, this user should not have the ability to make grant decisions

What is the correct way to do this?

Show Suggested Answer Hide Answer
Suggested Answer: D

The with managed access parameter on the schema enables the schema owner to control the grant and revoke privileges on the objects within the schema. This way, the user who owns the table cannot make grant decisions, but only the schema owner can. This is the best way to centralize grant management and maximize security.


by Arlen at Nov 19, 2024, 03:52 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Lawrence
22 days ago
Wait, why would we grant ownership to the user in the first place? That seems like a security risk. I'm gonna go with option C on this one.
upvoted 0 times
Nickolas
4 days ago
Revoking grant decisions from the user on the schema would limit their ability to make security decisions.
upvoted 0 times
...
Malissa
16 days ago
Granting ownership to the user on the table allows them to manage the data within that table.
upvoted 0 times
...
...
Dominga
1 months ago
Haha, this question reminds me of that time I accidentally gave someone full ownership on a critical table. Good times, good times. Anyway, I'm leaning towards option C as well.
upvoted 0 times
Delmy
22 hours ago
Tonette: Definitely don't want a repeat of accidentally giving full ownership to the wrong person!
upvoted 0 times
...
Nan
4 days ago
User 3: I agree, option C seems like the most secure choice in this situation.
upvoted 0 times
...
Tonette
11 days ago
User 2: Yeah, that sounds like the best option to prevent any accidental changes.
upvoted 0 times
...
Rebecka
12 days ago
User 1: I think the correct way is to revoke grant decisions from the user on the schema.
upvoted 0 times
...
...
Vashti
1 months ago
Option D with the 'with managed access' parameter sounds interesting, but I'm not sure if that's the correct way to handle this scenario. Hmm, need to do some more research.
upvoted 0 times
Tasia
6 days ago
Option D with the 'with managed access' parameter sounds interesting, but I'm not sure if that's the correct way to handle this scenario. Hmm, need to do some more research.
upvoted 0 times
...
Audrie
11 days ago
C) Revoke grant decisions from the user on the schema.
upvoted 0 times
...
Dylan
26 days ago
A) Grant ownership to the user on the table
upvoted 0 times
...
...
Antione
1 months ago
I would go with granting ownership to the user on the table, that way they have control without making grant decisions.
upvoted 0 times
...
Herminia
2 months ago
I disagree, I believe the best option is to add the with managed access parameter on the schema for better security.
upvoted 0 times
...
Luisa
2 months ago
I think the correct way is to revoke grant decisions from the user on the schema.
upvoted 0 times
...
Rachael
2 months ago
I think option C is the way to go. Revoking grant decisions from the user on the schema seems like the most straightforward approach.
upvoted 0 times
Esteban
1 months ago
Adding the with managed access parameter on the schema could also be a good solution.
upvoted 0 times
...
Teddy
2 months ago
I think it's better to revoke grant decisions on the schema to ensure security.
upvoted 0 times
...
Rosann
2 months ago
But wouldn't granting ownership to the user on the table also work?
upvoted 0 times
...
Viola
2 months ago
I agree, option C is the best choice. Revoking grant decisions on the schema is the way to go.
upvoted 0 times
...
...

Save Cancel