Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam
Go to Exam

Exam SnowPro Core topic 1 question 405 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 405
Topic #: 1
[All SnowPro Core Questions]

A developer is granted ownership of a table that has a masking policy. The developer’s role is not able to see the masked data.

Will the developer be able to modify the table to read the 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.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by halol at Dec. 21, 2022, 7:59 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
miadiesel
Highly Voted 1 year, 11 months ago
Selected Answer: D
Object owners (i.e. the role that has the OWNERSHIP privilege on the object) do not have the privilege to unset masking policies. Object owners cannot view column data in which a masking policy applies. https://docs.snowflake.com/en/user-guide/security-column-intro.html#what-are-masking-policies
upvoted 5 times
...
d22770a
Most Recent 1 month, 1 week ago
The question here is Will the developer be able to modify the table to read the masked data? It is about modifying the table to read the data from masked column. Owner of the table can definitely UNSET the masking policy by using this command ALTER TABLE <name> modify column <col_name> unset masking policy;
upvoted 1 times
...
_yyukta
8 months, 3 weeks ago
Selected Answer: D
D is correct
upvoted 1 times
...
[Removed]
1 year ago
Selected Answer: D
OWNERSHIP Grants full control over the masking policy. Required to alter most properties of a masking policy. Only a single role can hold this privilege on a specific object at a time.
upvoted 1 times
...
AlexbDku
1 year, 10 months ago
Selected Answer: D
https://docs.snowflake.com/en/user-guide/security-column-intro.html#what-are-masking-policies:~:text=Object%20owners%20(i.e.%20the%20role%20that%20has%20the%20OWNERSHIP%20privilege%20on%20the%20object)%20do%20not%20have%20the%20privilege%20to%20unset%20masking%20policies
upvoted 2 times
...
halol
1 year, 11 months ago
Selected Answer: D
Object owners (i.e. the role that has the OWNERSHIP privilege on the object) do not have the privilege to unset masking policies. Object owners cannot view column data in which a masking policy applies. https://docs.snowflake.com/en/user-guide/security-column-intro.html#what-are-masking-policies
upvoted 3 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel