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

Arcitura Education S90.19 Exam - Topic 4 Question 41 Discussion

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?
C) The database security should be increased so that the account under which Service A executes SQL queries has restricted access.
A) Stored procedures should be used instead of executing an SQL query that is determined at runtime.
B) The Message Screening pattern needs to be applied to Service A
D) None of the above

Arcitura Education S90.19 Exam - Topic 4 Question 41 Discussion

Actual exam question for Arcitura Education's S90.19 exam
Question #: 41
Topic #: 4
[All S90.19 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Gearldine at May 09, 2022, 09:20 AM

Limited Time Offer

25%

Off

Get Premium S90.19 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Lovetta
10 months ago
None of these options seem foolproof to me.
upvoted 0 times
...
Raina
10 months ago
Increasing database security sounds like a solid plan.
upvoted 0 times
...
Tegan
11 months ago
Wait, how did they even access confidential data?
upvoted 0 times
...
Sylvie
11 months ago
I disagree, the Message Screening pattern could work better.
upvoted 0 times
...
Pauline
11 months ago
Stored procedures are definitely the way to go!
upvoted 0 times
...
Eden
11 months ago
This one seems straightforward - I think the answer is A, realized and earned.
upvoted 0 times
...
Catina
11 months 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.
upvoted 0 times
...
Wenona
11 months 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.
upvoted 0 times
...
Idella
11 months 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.
upvoted 0 times
...

Save Cancel