DP-201 Exam QuestionsBrowse all questions from this exam

DP-201 Exam - Question 136


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.

Show Answer
Correct Answer: BD

To identify queries that return confidential information and the users who executed the queries efficiently, two key components are necessary. Sensitivity-classification labels applied to columns containing confidential information will help in categorizing and identifying data that is considered sensitive. Audit logs sent to a Log Analytics workspace will then track and record the queries executed by users, enabling quick identification of both the queries that accessed confidential information and the users who executed those queries. Dynamic data masking is used to obfuscate data and resource tags help in managing resources, but neither directly addresses the requirements of identifying queries and users.

Discussion

4 comments
Sign in to comment
DirectX
Apr 30, 2021

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

SorinXp
Jun 9, 2021

B and D

BobFar
Jun 6, 2021

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.

massnonn
Nov 11, 2021

For me B - D is the answer correct