Snowflake Exam DEA-C01 Topic 5 Question 39 Discussion

Actual exam question for Snowflake's DEA-C01 exam

Question #: 39
Topic #: 5

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?

AGrant ownership to the user on the table

BRevoke grant decisions from the user on the table

CRevoke grant decisions from the user on the schema.

DAdd the with managed access parameter on the schema

Show Suggested 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

Dominga

23 hours 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

7 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

...