SnowPro Advanced: Data Engineer — Question 43

A Data Engineer wants to centralize grant management to maximize security. A user needs OWNERSHIP on a table in a new schema. However, this user should not have the ability to make grant decisions.
What is the correct way to do this?

Answer options

• A. Grant OWNERSHIP to the user on the table.
• B. Revoke grant decisions from the user on the table.
• C. Revoke grant decisions from the user on the schema.
• D. Add the WITH MANAGED ACCESS parameter on the schema.

Correct answer: D

Explanation

The correct option is D because using the WITH MANAGED ACCESS parameter on the schema allows the user to have ownership of the table while preventing them from making grant decisions. Option A gives complete ownership, including grant rights, while options B and C do not address the ownership requirements effectively.