Microsoft Exam AZ-500 Topic 7 Question 65 Discussion

Actual exam question for Microsoft's AZ-500 exam

Question #: 65
Topic #: 7

[All AZ-500 Questions]

You have an Azure SQL Database server named SQL1.

You plan to turn on Advanced Threat Protection for SQL1 to detect all threat detection types.

Which action will Advanced Threat Protection detect as a threat?

AA user updates more than 50 percent of the records in a table.

BA user attempts to sign as SELECT * from table1.

CA user is added to the db_owner database role.

DA user deletes more than 100 records from the same table.

Show Suggested Answer

Suggested Answer: B

by Janine at Jul 07, 2024, 07:59 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

4 days ago

Hmm, I'm going with C. Adding a user to db_owner is a pretty serious change, that's gotta be the one Azure is looking for.

upvoted 0 times

...

8 days ago

Option B sounds like a common activity, how is that a threat? Sneaky Azure trying to catch us doing our jobs!

upvoted 0 times

...

19 days ago

Hmm, that's interesting. Can you explain why you think that is the correct answer?

upvoted 0 times

...

20 days ago

I disagree, I believe the correct answer is D) A user deletes more than 100 records from the same table.

upvoted 0 times

...

24 days ago

I think the answer is A) A user updates more than 50 percent of the records in a table.

upvoted 0 times

...