SnowPro Advanced Data Engineer Exam

Exam SnowPro Advanced Data Engineer All QuestionsBrowse all questions from this exam

Go to Exam

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?

ALTER TABLE customer MODIFY COLUMN full_name

SET MASKING POLICY name policy;

ALTER TABLE customer MODIFY COLUMN full_name

ADD MASKING POLICY name_policy;

ALTER TABLE customer MODIFY COLUMN

first_name SET MASKING POLICY name_policy,

last_name SET MASKING POLICY name_policy;

ALTER TABLE customer MODIFY COLUMN

first_name ADD MASKING POLICY name_policy,

last_name SET MASKING POLICY name_policy;

Correct Answer: C

The full_name column in the customer table is a virtual column, created using the CONCAT function to combine the first_name and last_name columns. Masking policies cannot be applied directly to virtual columns. Therefore, we need to apply the masking policy on the first_name and last_name columns individually. Option C correctly applies the masking policy to both first_name and last_name columns.

Discussion

azure_bimonsterOption: C

A virtual column is similar to a normal table column but it is defined by an expression. The result of evaluation of this expression becomes the value of the column. If we look at full_name column it came with concat function that was used making it as a virtual column. So, C would be correct here.

sajeskiOption: C

Masking policy cannot be attached to a VIRTUAL_COLUMN column. so it has to be C.

Snow_POption: A

For sure it's SET not ADD but wondering between A and C