DEA-C02 Question #65: Real Exam Question with Answer & Explanation

Question

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?

Options

• AALTER TABLE customer MODIFY COLUMN full_name
• BALTER TABLE customer MODIFY COLUMN full_name
• CALTER TABLE customer MODIFY COLUMN
• DALTER TABLE customer MODIFY COLUMN

Explanation

Note: The answer choices in this question appear to be truncated - the distinguishing SQL syntax after MODIFY COLUMN is cut off. Based on the Snowflake SnowPro exam context, here is the explanation:

Option C is correct because it uses the proper Snowflake syntax to attach a masking policy to a column:

ALTER TABLE customer MODIFY COLUMN full_name SET MASKING POLICY <policy_name>;

The critical keyword is SET MASKING POLICY - this is how Snowflake links an existing policy object to a specific column. Options A and B are wrong because they likely use incorrect or incomplete syntax, such as missing SET MASKING POLICY or using a non-existent clause. Option D likely uses UNSET MASKING POLICY, which removes a policy rather than applying one.

Memory tip: Think "SET to protect, UNSET to expose" - SET MASKING POLICY applies the mask, UNSET MASKING POLICY removes it. The full command flows logically: alter the table → modify the column → set its masking policy.

No community discussion yet for this question.