Microsoft Exam DP-203 Topic 1 Question 104 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 104
Topic #: 1

You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email.

You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of aXXX@XXXX.com instead.

What should you do?

AFrom Microsoft SQL Server Management Studio, set an email mask on the Email column.

BFrom the Azure portal, set a mask on the Email column.

CFrom Microsoft SQL Server Management studio, grant the SELECT permission to the users for all the columns in the dbo.Customers table except Email.

DFrom the Azure portal, set a sensitivity classification of Confidential for the Email column.

Show Suggested Answer

Suggested Answer: B

by Isabelle at Oct 24, 2024, 05:15 AM

Limited Time Offer

25%

Off

Get Premium DP-203 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Tammara

2 months ago

Hmm, I wonder if there's a way to make the masked email addresses a little more interesting, like 'aSuper_secret@email.com' or something. Just to keep things lively, you know?

upvoted 0 times

Helaine

10 days ago

Hmm, I wonder if there's a way to make the masked email addresses a little more interesting, like 'aSuper_secret@email.com' or something. Just to keep things lively, you know?

upvoted 0 times

...

Fatima

11 days ago

B) From the Azure portal, set a mask on the Email column.

upvoted 0 times

...

Jess

14 days ago

A) From Microsoft SQL Server Management Studio, set an email mask on the Email column.

upvoted 0 times

...

Tammara

2 months ago

Option C might work, but it seems like a bit of a hassle to grant selective permissions. I'd rather just set the mask and be done with it.

upvoted 0 times

Sharee

2 days ago

D) From the Azure portal, set a sensitivity classification of Confidential for the Email column.

upvoted 0 times

...

Cecil

3 days ago

A) Setting an email mask would be the easiest solution.

upvoted 0 times

...

Jolanda

4 days ago

B) From the Azure portal, set a mask on the Email column.

upvoted 0 times

...

Emily

9 days ago

A) From Microsoft SQL Server Management Studio, set an email mask on the Email column.

upvoted 0 times

...

Keva

2 months ago

Haha, I bet the users are going to love seeing 'aXXX@XXXX.com' instead of their actual email addresses. Maybe we should give them a heads up to avoid any confusion.

upvoted 0 times

Vashti

10 days ago

Haha, I bet the users are going to love seeing 'aXXX@XXXX.com' instead of their actual email addresses. Maybe we should give them a heads up to avoid any confusion.

upvoted 0 times

...

Olga

11 days ago

B) From the Azure portal, set a mask on the Email column.

upvoted 0 times

...

Anglea

1 months ago

A) From Microsoft SQL Server Management Studio, set an email mask on the Email column.

upvoted 0 times

...

Louann

2 months ago

I'm leaning towards option D. Classifying the Email column as Confidential seems like a more robust security measure that will apply across the board.

upvoted 0 times

Nana

8 days ago

It's a more comprehensive approach to securing the data.

upvoted 0 times

...

Peggie

20 days ago

That way, the email addresses will be protected.

upvoted 0 times

...

Patria

22 days ago

Setting a sensitivity classification of Confidential sounds like a good idea.

upvoted 0 times

...

Renato

1 months ago

I think option D is the best choice.

upvoted 0 times

...

Ayesha

2 months ago

I'm not sure, but setting a mask on the Email column from the Azure portal could also work, right?

upvoted 0 times

...

Lavina

2 months ago

I think option B is the way to go. Setting a mask on the column directly from the Azure portal sounds like the easiest and most straightforward approach.

upvoted 0 times