Answer-first summary for fast verification
Answer: No, because ownership of a table does not include the ability to change masking policies.
The correct answer is D because Snowflake documentation explicitly states that object owners (roles with OWNERSHIP privilege) do not have the privilege to unset masking policies. Even though the developer owns the table, masking policies are security controls that require specific privileges beyond ownership to modify or remove. The community discussion shows strong consensus for answer D with multiple references to official documentation and high upvotes, while one dissenting comment suggesting owners can unset masking policies has lower support and contradicts the official documentation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A developer owns a table that has a masking policy applied. The developer's current role cannot see the unmasked data.
Can the developer alter the table to view the previously masked data?
A
Yes, because a table owner has full control and can unset masking policies.
B
Yes, because masking policies only apply to cloned tables.
C
No, because masking policies must always reference specific access roles.
D
No, because ownership of a table does not include the ability to change masking policies.