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_name SET MASKING POLICY name policy;
B.
ALTER TABLE customer MODIFY COLUMN full_name ADD MASKING POLICY name_policy;
C.
ALTER TABLE customer MODIFY COLUMN first_name SET MASKING POLICY name_policy, last_name SET MASKING POLICY name_policy;
D.
ALTER TABLE customer MODIFY COLUMN first_name ADD MASKING POLICY name_policy, last_name SET MASKING POLICY name_policy;
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.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
azure_bimonster
7 months agosajeski
7 months, 1 week agoSnow_P
7 months, 3 weeks ago