exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 3 question 7 discussion

Actual exam question from Microsoft's DP-203
Question #: 7
Topic #: 3
[All DP-203 Questions]

You are designing an Azure Synapse Analytics dedicated SQL pool.
You need to ensure that you can audit access to Personally Identifiable Information (PII).
What should you include in the solution?

  • A. column-level security
  • B. dynamic data masking
  • C. row-level security (RLS)
  • D. sensitivity classifications
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Podavenna
Highly Voted 2 years, 7 months ago
Correct answer!
upvoted 27 times
...
Deeksha1234
Highly Voted 1 year, 8 months ago
Selected Answer: D
An important aspect of the classification is the ability to monitor access to sensitive data. Azure SQL Auditing has been enhanced to include a new field in the audit log called data_sensitivity_information. This field logs the sensitivity classifications (labels) of the data that was returned by a query. Ref - https://docs.microsoft.com/en-us/azure/azure-sql/database/data-discovery-and-classification-overview?view=azuresql
upvoted 6 times
...
kkk5566
Most Recent 8 months ago
Selected Answer: D
correct
upvoted 1 times
...
vctrhugo
10 months, 1 week ago
Selected Answer: D
By implementing Data Discovery & Classification we can Audit access to sensitive data. https://learn.microsoft.com/en-us/azure/azure-sql/database/data-discovery-and-classification-overview?view=azuresql#audit-sensitive-data
upvoted 1 times
...
kornat
1 year ago
correct
upvoted 1 times
...
TimboobmiT
1 year, 6 months ago
Why not dynamic data masking?
upvoted 2 times
vctrhugo
10 months, 1 week ago
Data mask you hide the data, but can't audit who read it.
upvoted 3 times
...
...
juanlu46
2 years ago
Selected Answer: D
Is correct! https://docs.microsoft.com/en-us/azure/azure-sql/database/data-discovery-and-classification-overview#audit-sensitive-data
upvoted 3 times
...
AlCubeHead
2 years ago
Correct!
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago