If the user loads this column data into another column that does not have a masking policy, what will occur?

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.

View Answer

Answer: A

Explanation:

According to the SnowPro Advanced: Architect documents and learning resources, column masking policies are applied at query time based on the privileges of the user who runs the query. Therefore, if a user has the privilege to see unmasked data in a column, they will see the original data when they query that column. If they load this column data into another column that does not have a masking policy, the unmasked data will be loaded in the new column, and any user who can query the new column will see the unmasked data as well. The masking policy does not affect the underlying data in the column, only the query results.

Reference: Snowflake Documentation: Column Masking

Snowflake Learning: Column Masking