Exam DP-201 topic 3 question 32 discussion

Actual exam question from Microsoft's DP-201

Question #: 32
Topic #: 3

You plan to create an Azure Synapse Analytics dedicated SQL pool.
You need to minimize the time it takes to identify queries that return confidential information as defined by the company's data privacy regulations and the users who executed the queries.
Which two components should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. dynamic data masking for columns that contain confidential information
B. sensitivity-classification labels applied to columns that contain confidential information
C. resource tags for databases that contain confidential information
D. audit logs sent to a Log Analytics workspace

Show Suggested Answer

Suggested Answer: AB 🗳️
Reference:
https://www.sqlshack.com/understanding-azure-synapse-analytics-formerly-sql-dw/
Design for high availability and disaster recovery

by DirectX at April 30, 2021, 3:15 p.m.

Comments

Submit Cancel

DirectX

Highly Voted 4 years, 1 month ago

The solution needs to identify the users who executed queries, not to hide confidental information. I guess that B,D is the answer.

upvoted 43 times

...

massnonn

Most Recent 3 years, 6 months ago

For me B - D is the answer correct

upvoted 1 times

...

SorinXp

3 years, 12 months ago

B and D

upvoted 3 times

...

BobFar

4 years ago

BD is the correct answer , when you need to minimize the time it takes to identify queries that return confidential information as defined by the company data privacy regulations and the users who executed the queries. A (dynamic data masking) is usable to mask data.

upvoted 2 times

...