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.
For sure it's SET not ADD but wondering between A and C
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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
2 weeks, 3 days agosajeski
3 weeks, 1 day agoSnow_P
1 month ago