Your consulting company has been asked to enhance an existing application. The current
application is a two-tier system in which all the business logic is located in thick clients. You are
considering a solution that would involve moving the business logic into the server’s database In
the form of stored procedures.
Which statement is an expected outcome of your proposed solution?
A.
It will improve the scalability of the system.
B.
It will improve the manageability of the system.
C.
It will recline the amount of traffic on the network.
D.
It will, in effect, turn the application into a three-tier system.
Explanation:
A
C
A
https://docs.oracle.com/cd/F49540_01/DOC/java.815/a64686/01_intr3.htm
“Stored procedures increase scalability by isolating application processing on the server. In addition, automatic dependency tracking for stored procedures aids the development of scalable applications.”
B is correct in the context of question.
Because the business logic is stored in thick clients and now we are considering a solution that would move business logic to server database in the form of stored procedure.
https://docs.oracle.com/cd/F49540_01/DOC/java.815/a64686/01_intr3.htm
“Once it is validated, a stored procedure can be used with confidence in any number of applications. If its definition changes, only the procedure is affected, not the applications that call it. This simplifies maintenance and enhancement. Also, maintaining a procedure on the server is easier than maintaining copies on various client machines.
“
I think A is correct
I think A. regarding B, manageability is not the same as maintainability
A is correct answer.
B is not correct answer – Manageability is the ease with which the administrators can monitor the system, through critical health status exposed through its monitoring capabilities. This is the ability of the system or the group of the system to provide key information to the ops team to be able to debug, analyse and understand the root cause of failures. It deals with compliance with the domain frameworks and policies.
The key is designing an application which is simple to manage, by publishing critical health status information from the monitoring capabilities and for analyzing the root cause of failures.