exam questions

Exam AZ-500 All Questions

View all questions & answers for the AZ-500 exam

Exam AZ-500 topic 5 question 5 discussion

Actual exam question from Microsoft's AZ-500
Question #: 5
Topic #: 5
[All AZ-500 Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
SecurityAnalyst
Highly Voted 3 years, 8 months ago
# IN EXAM - 31/8/2021
upvoted 9 times
...
WhalerTom
Highly Voted 3 years, 4 months ago
Correct answer. In exam Dec 21. 40 questions, 1 case study, no labs.
upvoted 8 times
...
xRiot007
Most Recent 9 months, 1 week ago
I would expect B - this is a potential injection attempt.
upvoted 1 times
...
saira23
9 months, 2 weeks ago
In Exam20/07/2024
upvoted 3 times
...
scottyboy23
9 months, 3 weeks ago
on exam 20240715. correct
upvoted 2 times
...
Ivan80
1 year, 3 months ago
In exam 1/28/24
upvoted 3 times
...
zellck
1 year, 12 months ago
Selected Answer: B
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.
upvoted 4 times
zellck
1 year, 11 months ago
Gotten this in May 2023 exam.
upvoted 5 times
...
...
Psychosikh
2 years ago
In exam 15/04/2023
upvoted 4 times
...
majstor86
2 years, 2 months ago
Selected Answer: B
B. A user attempts to sign in as SELECT * FROM table1 (Typical SQL injection)
upvoted 4 times
stepman
2 years ago
I chose this. This was On exam 4/27 with the new exam experience. No Sim or lab.
upvoted 2 times
...
...
F117A_Stealth
2 years, 5 months ago
Selected Answer: B
B SQL Injection
upvoted 3 times
...
Diallo18
2 years, 6 months ago
In Exam 10/18/2022. One case study(6 ques), no lab.
upvoted 3 times
...
Amit3
2 years, 7 months ago
# In Exam 01-Oct-2022, correct answer.
upvoted 2 times
...
ad7399
3 years, 5 months ago
B is an attempt to brute force sql credentials. https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/threat-detection-configure
upvoted 3 times
matetav
3 years, 4 months ago
It is SQL injection not brute force!!!
upvoted 6 times
...
...
Jco
3 years, 7 months ago
#exam ques # 29 Sep
upvoted 1 times
...
kam117
3 years, 7 months ago
## Exam Question - 24 Sept 2021 ##
upvoted 1 times
...
TonytheTiger
3 years, 7 months ago
## Exam Question - 17 Sept 2021 ##
upvoted 1 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