Microsoft Exam DP-300 Topic 8 Question 49 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 49
Topic #: 8

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 the Azure portal, set a mask on the Email column.

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

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

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

Show Suggested Answer

Suggested Answer: B

The Email masking method, which exposes the first letter and replaces the domain with XXX.com using a constant string prefix in the form of an email address.

Example: aXX@XXXX.com

by Roslyn at May 09, 2022, 04:04 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!