New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

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?

AStored procedures should be used instead of executing an SQL query that is determined at runtime.

BThe Message Screening pattern needs to be applied to Service A

CThe database security should be increased so that the account under which Service A executes SQL queries has restricted access.

DNone of the above

Show Suggested 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:

Submit Cancel

Lovetta

4 months ago

None of these options seem foolproof to me.

upvoted 0 times

...

Raina

4 months ago

Increasing database security sounds like a solid plan.

upvoted 0 times

...

Tegan

4 months ago

Wait, how did they even access confidential data?

upvoted 0 times

...

Sylvie

4 months ago

I disagree, the Message Screening pattern could work better.

upvoted 0 times

...

Pauline

5 months ago

Stored procedures are definitely the way to go!

upvoted 0 times

...

Eden

5 months ago

This one seems straightforward - I think the answer is A, realized and earned.

upvoted 0 times

...

Catina

5 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

5 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

5 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

...