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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft AZ-500 Exam - Topic 7 Question 65 Discussion

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?
B) A user attempts to sign as SELECT * from table1.
A) A user updates more than 50 percent of the records in a table.
C) A user is added to the db_owner database role.
D) A user deletes more than 100 records from the same table.

Microsoft AZ-500 Exam - 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

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:

0/2000 characters
Submit Cancel
Malcolm
7 months ago
Definitely not B, that's a normal query!
upvoted 0 times
...
Cristina
7 months ago
Option A seems risky too, but not sure if it's a threat.
upvoted 0 times
...
Bo
8 months ago
Wait, can Advanced Threat Protection really catch that?
upvoted 0 times
...
Sharen
8 months ago
Agree, deleting over 100 records is suspicious!
upvoted 0 times
...
Joseph
8 months ago
I think option D is a clear threat detection.
upvoted 0 times
...
Hermila
8 months ago
I practiced a similar question where excessive SELECT statements were flagged, so option B might be relevant, but I'm not completely confident.
upvoted 0 times
...
Raul
9 months ago
I feel like option C could be a threat too, but I can't recall if adding to db_owner triggers any alerts.
upvoted 0 times
...
Christa
9 months ago
I think option D sounds familiar because I practiced a question about detecting large deletions. That might be the right choice.
upvoted 0 times
...
Mozelle
9 months ago
I remember reading about Advanced Threat Protection, but I'm not sure if it detects bulk updates like option A.
upvoted 0 times
...
Buck
9 months ago
I'm feeling pretty confident on this one. I think the key is understanding that Advanced Threat Protection is looking for anomalous behavior, not just authorized changes. So option B about the SELECT * attempt is probably the right answer.
upvoted 0 times
...
Meghan
9 months ago
Based on the options, it seems like it would detect a user attempting to access data they shouldn't have, like trying to SELECT all records from a table. That seems like the kind of suspicious activity it's designed to catch.
upvoted 0 times
...
Lindsey
9 months ago
I'm a bit confused on the specifics here. Does it matter if the user is authorized to make those changes, or is it just the volume of activity that triggers the detection?
upvoted 0 times
...
Keshia
9 months ago
Okay, let's see. I know it detects unusual activity, so I'm guessing it would pick up on a user making a large number of changes to the database.
upvoted 0 times
...
Vivan
9 months ago
Hmm, this seems like a tricky one. I'll need to think carefully about the different threat detection types that Advanced Threat Protection covers.
upvoted 0 times
...
Markus
9 months ago
Quick action seems like it could be a good option here. That would allow the user to quickly delete the phone number with a single click when the DoNotCall box is checked.
upvoted 0 times
...
Rosalind
1 year 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 year 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 year ago
User1: Let's go with B then.
upvoted 0 times
...
Dortha
1 year ago
User2: Yeah, trying to sign as SELECT * from a table does seem like a threat.
upvoted 0 times
...
Talia
1 year ago
User1: I think B sounds pretty suspicious too.
upvoted 0 times
...
...
In
1 year 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
1 year ago
User 3: Maybe Azure just wants to be extra cautious with security.
upvoted 0 times
...
Caitlin
1 year ago
User 2: Yeah, I agree. A and D seem like regular actions.
upvoted 0 times
...
Tyra
1 year ago
User 1: I think Azure is just being paranoid about normal database maintenance.
upvoted 0 times
...
...
Zack
1 year 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
1 year ago
C) A user is added to the db_owner database role.
upvoted 0 times
...
Mitsue
1 year ago
B) A user attempts to sign as SELECT * from table1.
upvoted 0 times
...
Leslie
1 year ago
A) A user updates more than 50 percent of the records in a table.
upvoted 0 times
...
...
Nohemi
1 year 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
1 year ago
D: It's always good to have that extra layer of security in place to protect our data.
upvoted 0 times
...
Sue
1 year 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 year ago
B: Really? I didn't realize that, thanks for the info.
upvoted 0 times
...
Ressie
1 year ago
A: I think option B is considered a threat because it could be an attempt to access sensitive data.
upvoted 0 times
...
...
Kimbery
1 year ago
Hmm, that's interesting. Can you explain why you think that is the correct answer?
upvoted 0 times
...
Charlena
1 year 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
1 year 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