snowpro-advanced-data-engineer question 65 discussion

Question 65

A Data Engineer defines the following masking policy:

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

Which query will apply the masking policy on the full_name column?

• A. ALTER TABLE customer MODIFY COLUMN full_nameSET MASKING POLICY name policy;
• B. ALTER TABLE customer MODIFY COLUMN full_nameADD MASKING POLICY name_policy;
• C. ALTER TABLE customer MODIFY COLUMNfirst_name SET MASKING POLICY name_policy,last_name SET MASKING POLICY name_policy;
• D. ALTER TABLE customer MODIFY COLUMNfirst_name ADD MASKING POLICY name_policy,last_name SET MASKING POLICY name_policy;