New Year Sale ! 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
5 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
...
Dominga
17 days 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
...
Vashti
23 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
Dylan
9 days ago
A) Grant ownership to the user on the table
upvoted 0 times
...
...
Antione
26 days 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
30 days 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
1 months ago
I think the correct way is to revoke grant decisions from the user on the schema.
upvoted 0 times
...
Rachael
1 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
17 days ago
Adding the with managed access parameter on the schema could also be a good solution.
upvoted 0 times
...
Teddy
1 months ago
I think it's better to revoke grant decisions on the schema to ensure security.
upvoted 0 times
...
Rosann
1 months ago
But wouldn't granting ownership to the user on the table also work?
upvoted 0 times
...
Viola
1 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