You are designing an ASP.NET Web application that displays daily sales information. The
sales information is stored in a large Microsoft SQL Server database. The database
information is updated each night. During the day, people use the Web application to
display a set of standard sales reports based on the latest database information. The SQL
queries that are required to retrieve the database information can take from 20 to 30
seconds to execute. You need to design the application to ensure that pages usually load in
no more than 5 seconds. Which two approaches could you recommend? (Each correct
answer presents a complete solution. Choose two.)
A.
Use a control that retrieves and displays the database information
B.
Use AJAX to retrieve the database information
C.
Use a service that proxies the database queries and caches the results
D.
Use SQL Server replication