Exam AZ-500 topic 5 question 61 discussion

Actual exam question from Microsoft's AZ-500

Question #: 61
Topic #: 5

HOTSPOT
-

You have an Azure SQL database named DB1 that contains a table named Tablet.

You need to configure DB1 to meet the following requirements:

• Sensitive data in Table1 must be identified automatically.
• Only the first character and last character of the sensitive data must be displayed in query results.

Which two features should you configure? To answer, select the features in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by skr123 at Jan. 12, 2023, 9:14 a.m.

Comments

Submit Cancel

zellck

Highly Voted 1 year, 1 month ago

1. Data Discovery & Classification 2. Dynamic Data Masking https://learn.microsoft.com/en-us/azure/azure-sql/database/data-discovery-and-classification-overview?view=azuresql Data Discovery & Classification is built into Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics. It provides basic capabilities for discovering, classifying, labeling, and reporting the sensitive data in your databases.

upvoted 11 times

zellck

1 year, 1 month ago

https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview?view=azuresql Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics support dynamic data masking. Dynamic data masking limits sensitive data exposure by masking it to nonprivileged users. Dynamic data masking helps prevent unauthorized access to sensitive data by enabling customers to designate how much of the sensitive data to reveal with minimal effect on the application layer. It's a policy-based security feature that hides the sensitive data in the result set of a query over designated database fields, while the data in the database isn't changed.

upvoted 4 times

...