MENU
Service A contains reporting logic that issues SOL queries against a database to generate reports. The actual SQL query syntax is determined at runtime. It has been reported that some of these queries ended up retrieving highly confidential data by accessing tables that service consumers were not authorized for. How can this be avoided?
Suggested Answer: C
Get Premium S90.19 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
9 comments · newest first
LO
Lovetta
12 months ago
None of these options seem foolproof to me.
RA
Raina
12 months ago
Increasing database security sounds like a solid plan.
TE
Tegan
1 year ago
Wait, how did they even access confidential data?
SY
Sylvie
1 year ago
I disagree, the Message Screening pattern could work better.
PA
Pauline
1 year ago
Stored procedures are definitely the way to go!
ED
Eden
1 year ago
This one seems straightforward - I think the answer is A, realized and earned.
CA
Catina
1 year ago
I remember practicing with a question similar to this, and I believe it's punishable by more than one year, so I'm leaning towards option C.
WE
Wenona
1 year ago
I vaguely recall the role of DevOps with Infrastructure as Code, so perhaps C is right, but A seems a bit off to me.
ID
Idella
1 year ago
Okay, I think I've got a good handle on this. The key is to choose the connectivity solution that meets the bandwidth and cost requirements.