You have an ASP.NET Web application. The Web application displays frequently changing
data. As application usage increases, more queries are issued. And the database response
time increases. You need to design a strategy for improving database query response time.
Which approach should you recommend?

A.
Use SQL Server replication

B.
Use network load balancing

C.
Use the application cache

D.
Use multiple active result sets