Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

Contribute your Thoughts:

Rosalind
3 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
3 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
Noemi
1 months ago
User1: Let's go with B then.
upvoted 0 times
...
Dortha
1 months ago
User2: Yeah, trying to sign as SELECT * from a table does seem like a threat.
upvoted 0 times
...
Talia
1 months ago
User1: I think B sounds pretty suspicious too.
upvoted 0 times
...
...
In
3 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
2 months ago
User 3: Maybe Azure just wants to be extra cautious with security.
upvoted 0 times
...
Caitlin
2 months ago
User 2: Yeah, I agree. A and D seem like regular actions.
upvoted 0 times
...
Tyra
3 months ago
User 1: I think Azure is just being paranoid about normal database maintenance.
upvoted 0 times
...
...
Zack
3 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
2 months ago
C) A user is added to the db_owner database role.
upvoted 0 times
...
Mitsue
2 months ago
B) A user attempts to sign as SELECT * from table1.
upvoted 0 times
...
Leslie
2 months ago
A) A user updates more than 50 percent of the records in a table.
upvoted 0 times
...
...
Nohemi
3 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
2 months ago
D: It's always good to have that extra layer of security in place to protect our data.
upvoted 0 times
...
Sue
3 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
3 months ago
B: Really? I didn't realize that, thanks for the info.
upvoted 0 times
...
Ressie
3 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
4 months ago
Hmm, that's interesting. Can you explain why you think that is the correct answer?
upvoted 0 times
...
Charlena
4 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
4 months ago
I think the answer is A) A user updates more than 50 percent of the records in a table.
upvoted 0 times
...

Save Cancel