Arcitura Education Exam S90.19 Topic 4 Question 41 Discussion

Actual exam question for Arcitura Education's S90.19 exam

Question #: 41
Topic #: 4

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

Currently there are no comments in this discussion, be the first to comment!