You have an Azure SQL Database server named SQL1. For SQL1, you turn on Azure Defender for SQL to detect all threat detection types. Which action will Azure Defender for SQL detect as a threat?
A.
A user updates more than 50 percent of the records in a table.
B.
A user attempts to sign in as SELECT * FROM table1.
C.
A user is added to the db_owner database role.
D.
A user deletes more than 100 records from the same table.
B is the answer.
https://learn.microsoft.com/en-us/azure/azure-sql/database/threat-detection-overview?view=azuresql#overview
Advanced Threat Protection provides a new layer of security, which enables customers to detect and respond to potential threats as they occur by providing security alerts on anomalous activities. Users receive an alert upon suspicious database activities, potential vulnerabilities, and SQL injection attacks, as well as anomalous database access and queries patterns. Advanced Threat Protection integrates alerts with Microsoft Defender for Cloud, which include details of suspicious activity and recommend action on how to investigate and mitigate the threat. Advanced Threat Protection makes it simple to address potential threats to the database without the need to be a security expert or manage advanced security monitoring systems.
This section is not available anymore. Please use the main Exam Page.AZ-500 Exam Questions
Log in to ExamTopics
Sign in:
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.
SecurityAnalyst
Highly Voted 3 years, 8 months agoWhalerTom
Highly Voted 3 years, 4 months agoxRiot007
Most Recent 9 months, 1 week agosaira23
9 months, 2 weeks agoscottyboy23
9 months, 3 weeks agoIvan80
1 year, 3 months agozellck
1 year, 12 months agozellck
1 year, 11 months agoPsychosikh
2 years agomajstor86
2 years, 2 months agostepman
2 years agoF117A_Stealth
2 years, 5 months agoDiallo18
2 years, 6 months agoAmit3
2 years, 7 months agoad7399
3 years, 5 months agomatetav
3 years, 4 months agoJco
3 years, 7 months agokam117
3 years, 7 months agoTonytheTiger
3 years, 7 months ago