exam questions

Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 12 question 1 discussion

Actual exam question from Microsoft's DP-201
Question #: 1
Topic #: 12
[All DP-201 Questions]

You need to design the unauthorized data usage detection system.
What Azure service should you include in the design?

  • A. Azure Analysis Services
  • B. Azure Synapse Analytics
  • C. Azure Databricks
  • D. Azure Data Factory
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
SQL Database and SQL Data Warehouse
SQL threat detection identifies anomalous activities indicating unusual and potentially harmful attempts to access or exploit databases.
Advanced Threat Protection for Azure SQL Database and SQL Data Warehouse detects anomalous activities indicating unusual and potentially harmful attempts to access or exploit databases.
Scenario:

Requirements. Security -
The solution must meet the following security requirements:
✑ Unauthorized usage of data must be detected in real time. Unauthorized usage is determined by looking for unusual usage patterns.
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-threat-detection-overview
Design for data security and compliance

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
bech1208
Highly Voted 4 years, 11 months ago
You need to use Advanced Threat Protection feature in Azure. The question states "data usage", which may lead to Synapse or Azure SQL DB. Hence the answer is Synapse (B) since there is no Azure SQL DB choice
upvoted 18 times
198981309810839189283928938298
4 years, 7 months ago
ATP is now known as Microsoft Defender for Identity
upvoted 4 times
...
...
vrao1
Most Recent 4 years, 4 months ago
This looks more relavant to requiring Databricks then synapse. "Unauthorized usage of data must be detected in real time. Unauthorized usage is determined by looking for unusual usage patterns."
upvoted 2 times
...
ACSC
4 years, 5 months ago
Same question at question #1 Topic 12. Answer is correct.
upvoted 1 times
...
ExamW
4 years, 11 months ago
Databricks?
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 ...