You are an enterprise application developer. You create a client application. One thousand customer service agents use the application during their core business hours, from 8:00 to 17:00.
The application confirms to the following design details:
* The application uses separate business logic components and data access logic components.
* The data components run on the client computer and connect to a central Microsoft SQL Server 2005 database server.
* When the application starts, it retrieves datasets to populate list boxes, drop-down list boxes, and TreeView controls that have data common to all users.
* Users are authenticated to the database by using Active Directory.
Users report that the application is slow to start. You need to recommend a solution so that the application starts normally. You want to achieve this goal with the minimum programming effort.
Which solution should you recommend?
A.
Change the data access component to use data readers instead of datasets. Redeploy the data access component.
B.
Implement a Least Recently Used Cache (LRUCache) on the client application in the business component. Redeploy the business component.
C.
Create a synchronization application to synchronize a local database with the central database. Modify the data access logic to connect to the local database if available, otherwise connect to the central database. Deploy Microsoft SQL Server 2005 Express Edition and the synchronization application. Redeploy the data access component.
D.
Enable SQL connection pooling by giving the application a SQL username and password.
Redeploy the configuration file.
E.
Install the data access component on a Web server and access it through a Web service.
Enable output caching on the Web service. Redeploy the business component.