Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake Exam DEA-C01 Topic 1 Question 45 Discussion

Actual exam question for Snowflake's DEA-C01 exam
Question #: 45
Topic #: 1
[All DEA-C01 Questions]

A Data Engineer defines the following masking 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?

Show Suggested Answer Hide Answer
Suggested Answer: A

The query that will apply the masking policy on the full_name column is ALTER TABLE customer MODIFY COLUMN full_name SET MASKING POLICY name_policy;. This query will modify the full_name column and associate it with the name_policy masking policy, which will mask the first and last names of the customers with asterisks. The other options are incorrect because they do not follow the correct syntax for applying a masking policy on a column. Option B is incorrect because it uses ADD instead of SET, which is not a valid keyword for modifying a column. Option C is incorrect because it tries to apply the masking policy on two columns, first_name and last_name, which are not part of the table structure. Option D is incorrect because it uses commas instead of dots to separate the database, schema, and table names


Contribute your Thoughts:

Brock
2 hours ago
This question is a piece of cake! The answer is clearly A, just like my favorite dessert.
upvoted 0 times
...
Kindra
1 days ago
But A makes more sense because it modifies the column and sets the masking policy.
upvoted 0 times
...
Aleta
2 days ago
I disagree, I believe the correct answer is D.
upvoted 0 times
...
Kindra
3 days ago
I think the correct answer is A.
upvoted 0 times
...
Alethea
10 days ago
Haha, option D is just asking to 'ADD' the masking policy, not 'SET' it. Rookie mistake!
upvoted 0 times
...
Rosio
12 days ago
I'm going with C. Splitting the 'first_name' and 'last_name' columns and applying the masking policy to each one seems like a valid approach.
upvoted 0 times
Viki
2 days ago
I disagree, I believe D is the right choice. Adding the masking policy directly to the full_name column seems more efficient.
upvoted 0 times
...
Colby
3 days ago
I think C is the correct option as well. Splitting the names and applying the masking policy separately makes sense.
upvoted 0 times
...
...
Merilyn
17 days ago
Option B is incorrect because 'full_nam' is not the correct column name. It should be 'full_name'.
upvoted 0 times
...
Vicki
20 days ago
I think the correct answer is A. The question clearly states that the masking policy must be applied to the 'full_name' column, so using 'ALTER TABLE customer MODIFY COLUMN full_name SET MASKING POLICY name_policy' is the correct way to do it.
upvoted 0 times
Veronica
2 days ago
I agree, option A is the right choice.
upvoted 0 times
...
Gladys
6 days ago
I think the correct answer is A.
upvoted 0 times
...
...

Save Cancel