Exam DP-203 topic 3 question 23 discussion

Actual exam question from Microsoft's DP-203

Question #: 23
Topic #: 3

You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Contacts. Contacts contains a column named Phone.
You need to ensure that users in a specific role only see the last four digits of a phone number when querying the Phone column.
What should you include in the solution?

A. table partitions
B. a default value
C. row-level security (RLS)
D. column encryption
E. dynamic data masking

Show Suggested Answer

Suggested Answer: E 🗳️

by PallaviPatel at Jan. 6, 2022, 10:30 a.m.

Comments

Submit Cancel

PallaviPatel

Highly Voted 2 years, 12 months ago

correct

upvoted 14 times

...

ANath

Highly Voted 2 years, 11 months ago

Correct

upvoted 5 times

...

jsav1

Most Recent 11 months, 3 weeks ago

Selected Answer: E

Correct

upvoted 1 times

...

74gjd_37

1 year, 3 months ago

Selected Answer: C

The correct answer is row level security ("to allow specific roles") See https://learn.microsoft.com/en-us/azure/data-explorer/kusto/management/rowlevelsecuritypolicy More use cases A call center support person may identify callers by several digits of their social security number. This number shouldn't be fully exposed to the support person. An RLS policy can be applied on the table to mask all but the last four digits of the social security number in the result set of any query.

upvoted 1 times

...

kkk5566

1 year, 4 months ago

Selected Answer: E

correct

upvoted 1 times

...

borinot

2 years, 1 month ago

And Topic 3 question 24 is column-level encryption?

upvoted 2 times

vrodriguesp

1 year, 10 months ago

I think the key is "when querying the Phone column". Column encryption encrypts individual columns of database on db level, instead Dynamic data masking does not store masked data, only display it.

upvoted 3 times

...