Exam DP-201 topic 9 question 3 discussion

Actual exam question from Microsoft's DP-201

Question #: 3
Topic #: 9

[All DP-201 Questions]

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)

Show Suggested Answer

Suggested Answer: A 🗳️
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

by AlexD332 at March 13, 2021, 3:51 p.m.

Comments

Submit Cancel

AlexD332

Highly Voted 4 years, 2 months ago

https://azure.microsoft.com/en-ca/updates/column-level-security-is-now-supported-in-azure-sql-data-warehouse/ You can use CLS to manage user access to specific columns in your tables in a simpler manner, without having to redesign your data warehouse. CLS eliminates the need to maintain access restriction logic away from the data in another application or introduce views for filtering out sensitive columns for a subset of users.

upvoted 23 times

Devendra00023

4 years, 1 month ago

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/column-level-security

upvoted 1 times

...

H_S

Highly Voted 4 years, 2 months ago

Wrong answer the correct one is B classification used at the audit level, but does not hide any information.

upvoted 11 times

...

savin

Most Recent 4 years ago

Should be column level security

upvoted 1 times

...

davita8

4 years, 1 month ago

B. column-level security

upvoted 4 times

...

AlexD332

4 years, 2 months ago

Data Discovery & Classification provides basic capabilities for discovering, classifying, labeling, and reporting the sensitive data in your databases. I don't see words protect, encrypt...

upvoted 3 times

...