exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 3 question 3 discussion

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

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 queues.
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. sensitivity-classification labels applied to columns that contain confidential information
  • B. resource tags for databases that contain confidential information
  • C. audit logs sent to a Log Analytics workspace
  • D. dynamic data masking for columns that contain confidential information
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️

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
damaldon
Highly Voted 3 years, 4 months ago
Correct!
upvoted 28 times
...
saty_nl
Highly Voted 3 years, 4 months ago
Answer is correct. Dynamic data masking will limit the exposure of sensitive data.
upvoted 11 times
...
Dusica
Most Recent 5 months, 2 weeks ago
B and C nobody mentions purview there
upvoted 1 times
...
Dusica
5 months, 3 weeks ago
The answer is B and C Sensitivity classification tags are part of Purview. Purview is a separate service, and an expensive one. The question does not mention Purview.
upvoted 1 times
...
kkk5566
1 year, 1 month ago
Selected Answer: AC
audit aand sensitivity-classification labels
upvoted 2 times
...
anks84
2 years, 1 month ago
Selected Answer: AC
Given Answers are correct !
upvoted 4 times
...
Deeksha1234
2 years, 2 months ago
correct
upvoted 3 times
...
Remedios79
2 years, 3 months ago
Also for me is correct
upvoted 2 times
...
sparkchu
2 years, 6 months ago
log auditing & tracing is important for data governance, therefore necessary for any data solution.
upvoted 2 times
...
rashjan
2 years, 10 months ago
Selected Answer: AC
correct
upvoted 2 times
...
rashjan
2 years, 10 months ago
Correct: "The solution needs to identify the users who executed queries, not to hide confidental information." thanks @DirectX from this discussion: https://www.examtopics.com/discussions/microsoft/view/51257-exam-dp-201-topic-3-question-32-discussion/
upvoted 8 times
...
dduque10
3 years, 1 month ago
Is it really C correct?
upvoted 1 times
Dizzystar
2 years, 11 months ago
wondering the same thing.
upvoted 1 times
...
rashjan
2 years, 10 months ago
Yes, the logs are used to identify the user who executed the query.
upvoted 3 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