A user has the appropriate privilege to see unmasked data in a column. If the user loads this column data into another column that does not have a masking policy, what will occur?
A.
Unmasked data will be loaded in the new column.
B.
Masked data will be loaded into the new column.
C.
Unmasked data will be loaded into the new column but only users with the appropriate privileges will be able to see the unmasked data.
D.
Unmasked data will be loaded into the new column and no users will be able to see the unmasked data.
A. Unmasked data will be loaded in the new column.
Here’s why:
When a user with appropriate privileges to see unmasked data loads data from a column with a masking policy into another column without a masking policy, the data loaded into the new column will be unmasked. This is because the user's privileges allow them to access the original data without the masking applied. Since the new column does not have a masking policy, it will simply store the data as it was accessed by the user, which in this case is unmasked.
Therefore, the new column will contain the unmasked data regardless of the masking policy on the original column, and no additional masking will be applied to the new column unless explicitly defined.
C
Use caution when inserting values from a source column that has a masking policy on the source column to a target column without a masking policy on the target column. Since a masking policy is set on the source column, a role that views unmasked column data can insert unmasked data into another column, where any role with sufficient privileges on the table or view can see the value.
If a role that sees masked data in the source column inserts those values into a target column, the inserted values remain masked.
https://docs.snowflake.com/en/user-guide/security-column-intro
Definitely A. "Since a masking policy is set on the source column, a role that views unmasked column data can insert unmasked data into another column, where any role with sufficient privileges on the table or view can see the value.". Doc: https://docs.snowflake.com/en/user-guide/security-column-intro
Definitely A. "Since a masking policy is set on the source column, a role that views unmasked column data can insert unmasked data into another column, where any role with sufficient privileges on the table or view can see the value.". Doc: https://docs.snowflake.com/en/user-guide/security-column-intro
"Since a masking policy is set on the source column, a role that views unmasked column data can insert unmasked data into another column, where any role with sufficient privileges on the table or view can see the value.". Doc: https://docs.snowflake.com/en/user-guide/security-column-intro
Your explanation point to A as the correct answer.
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
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.
laksnarn
5 months agoDBSS
6 months, 2 weeks agojjordan
11 months, 1 week agopapi97
11 months, 2 weeks agochagantik90
1 year, 3 months agohillcat111
1 year, 4 months agoNeedium
1 year, 6 months agoAlachramkowa
1 year, 6 months agoJay_98_11
1 year, 7 months agoNeedium
1 year, 6 months agojjordan
11 months, 1 week ago