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

Get Premium AZ-500 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Rosalind

1 months ago

Advanced Threat Protection? More like 'Advanced Paranoia Protection'. Azure's going to flag me for breathing too loudly next!

upvoted 0 times

...

Rory

1 months ago

I'm just going to pick the option that sounds the most ominous - 'Advanced Threat Protection' makes me think they're looking for some real shady stuff, so I'll go with B.

upvoted 0 times

Talia

5 days ago

User1: I think B sounds pretty suspicious too.

upvoted 0 times

...

In

2 months ago

A and D both sound like normal database maintenance to me. I bet Azure is just being paranoid about that.

upvoted 0 times

Hoa

18 days ago

User 3: Maybe Azure just wants to be extra cautious with security.

upvoted 0 times

...

Caitlin

20 days ago

User 2: Yeah, I agree. A and D seem like regular actions.

upvoted 0 times

...

Tyra

1 months ago

User 1: I think Azure is just being paranoid about normal database maintenance.

upvoted 0 times

...

Zack

2 months 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

Fatima

13 days ago

C) A user is added to the db_owner database role.

upvoted 0 times

...

Mitsue

19 days ago

B) A user attempts to sign as SELECT * from table1.

upvoted 0 times

...

Leslie

22 days ago

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

upvoted 0 times

...

Nohemi

2 months 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

Cherelle

27 days ago

D: It's always good to have that extra layer of security in place to protect our data.

upvoted 0 times

...

Sue

1 months ago

C: Yeah, Advanced Threat Protection is designed to detect any suspicious activity, even if it seems harmless at first.

upvoted 0 times

...

An

1 months ago

B: Really? I didn't realize that, thanks for the info.

upvoted 0 times

...

Ressie

2 months ago

A: I think option B is considered a threat because it could be an attempt to access sensitive data.

upvoted 0 times

...

Kimbery

2 months ago

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

upvoted 0 times

...

Charlena

2 months ago

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

upvoted 0 times

...

Kimbery

3 months ago

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

upvoted 0 times

...