SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ18

Implement Data Protection and Recovery

A Data Engineer creates the following masking policy:

Question Image

The policy must be assigned to the full_name column in the customer table:

Question Image

Which query applies the masking policy to the full_name column?

Explanation

For an existing Snowflake table, a masking policy is assigned with ALTER TABLE ... MODIFY COLUMN <column_name> SET MASKING POLICY <policy_name>. The policy must be attached to full_name, which is the column requiring protection, rather than to first_name and last_name.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!