This is a good test of our database knowledge. I'll review the options and try to eliminate the ones that don't quite fit the "business as usual" requirement.
Ah, I remember learning about the bp_dba roles in our Blue Prism training. I think that's the key to this question, but I want to double-check the specifics before answering.
Hmm, I'm not totally sure about the different database roles and permissions. I'll have to think this through carefully to make sure I select the right answer.
Okay, let's see... I know the dbowner role has full control, but that seems too broad for "business as usual" access. I'll have to weigh the other options to find the minimum required permissions.
Okay, let's see. Microsoft Defender is for endpoint security, so it's probably not going to help with sales or marketing issues. My best guess is that it would be used to resolve security problems for the executive team.
I've got a good feeling about C - DDoS attack. That type of attack is designed to overwhelm and shut down a server, which matches the description in the question. I'm going to go with that unless I spot something that makes me reconsider.
I think the correct answer is C. datareader, datawrter, and all roles named with a prefix of bp_dba. That sounds like the minimum permissions required for business as usual access.
Mariann
4 months agoRodrigo
4 months agoShay
4 months agoJanessa
4 months agoKristian
5 months agoLeota
5 months agoRaina
5 months agoKarma
5 months agoChandra
5 months agoTricia
5 months agoCecil
5 months agoJerilyn
5 months agoArdella
5 months agoTorie
6 months agoJovita
6 months agoEric
6 months agoFatima
6 months agoCiara
2 years agoWilliam
2 years agoDawne
2 years agoPeter
2 years agoMichael
2 years agoJuan
2 years agoIola
2 years agoDaren
2 years agoLashawnda
2 years agoWayne
2 years agoAdelle
2 years agoLoren
2 years agoLaurel
2 years agoBenton
2 years agoOnita
2 years agoLore
2 years agoDante
2 years agoErasmo
2 years agoShelton
2 years ago