SnowPro Advanced: Architect — Question 26

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?

Answer options

• 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.

Correct answer: A

Explanation

The correct answer is A because when a user with the right privileges loads unmasked data into a new column that lacks a masking policy, the data remains unmasked. Options B, C, and D are incorrect because they suggest that the data will either be masked or restricted in visibility, which does not happen in this scenario.