A company is in the business of distributing hard candies. The distribution of these candies is
automated and the system that helps track information about candy distribution is written in Java
technology. The business unit for the company has been asking the IT group to provide a flexible
reporting system to track detailed information. A large amount of data about candy is stored using
a DAO layer, but little is used. What is the best solution for the IT group to implement to provide
the most flexibility for the business unit?
A.
refactor the DAOs to include additional static queries to pull information and export a
spreadsheet for the business unit to review
B.
Implement an ad-hoc query tool exposed using JSF that allows business units to create
queries and produce results in a given format
C.
Provide a JSP page, which has scriptlets that expose pre-defined queries for the business
unit to execute and display in HTML
D.
Create a web service that exposes fixed queries invoked by a JSP client that can pull data
from the database and export in a given format