Home » Microsoft » DP-201 v.2 » What should you recommend using to secure sensitive customer contact information?
What should you recommend using to secure sensitive customer contact information?
A. data sensitivity labels
B. column-level security
C. row-level security
D. Transparent Data Encryption (TDE)
Correct Answer: A
Explanation/Reference:
Explanation:
Scenario: Limit the business analysts’ access to customer contact information, such as phone numbers, because this type of data is not analytically relevant.
Labeling: You can apply sensitivity-classification labels persistently to columns by using new metadata attributes that have been added to the SQL Server database engine. This metadata can then be used for advanced, sensitivity-based auditing and protection scenarios.
Incorrect Answers:
D: Transparent Data Encryption (TDE) encrypts SQL Server, Azure SQL Database, and Azure Synapse Analytics data files, known as encrypting data at rest. TDE does not provide encryption across communication channels.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/data-discovery-and-classification-overview
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-security-overview