ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-201 All Questions

View all questions & answers for the DP-201 exam
Go to Exam

Exam DP-201 topic 2 question 5 discussion

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

You are designing an audit strategy for an Azure SQL Database environment.
You need to recommend a solution to provide real-time notifications for potential security breaches. The solution must minimize development effort.
Which destination should you include in the recommendation?

  • A. Azure Blob storage
  • B. Azure Synapse Analytics
  • C. Azure Event Hubs
  • D. Azure Log Analytics
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
Auditing for Azure SQL Database and SQL Data Warehouse tracks database events and writes them to an audit log in your Azure storage account, Log Analytics workspace or Event Hubs.
Alerts in Azure Monitor can identify important information in your Log Analytics repository. They are created by alert rules that automatically run log searches at regular intervals, and if results of the log search match particular criteria, then an alert record is created and it can be configured to perform an automated response.
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing https://docs.microsoft.com/en-us/azure/azure-monitor/learn/tutorial-response
by bdloko at April 3, 2021, 11:21 a.m.

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
Submit Cancel
bdloko
Highly Voted 4 years, 2 months ago
Not C: Solution must minimize development effort. D: Alerts in Azure Monitor can identify important information in your Log Analytics repository.
upvoted 14 times
...
cadio30
Most Recent 4 years ago
Appropriate answer is azure log analytics as the it can be configured easily by sending the logs into the component
upvoted 2 times
...
maynard13x8
4 years, 2 months ago
Destination should be Azure storage because it’s the place where the logs are saved when you enable auditing.
upvoted 3 times
maynard13x8
4 years, 2 months ago
Sorry. D is correct. Bdloko is right.
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