You have an ASP NET Web application.
The Web application displays frequently changing data as application usage increases more quenes 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 the application cache
B.
Use SQL Server replication
C.
Use network load balancing
D.
Use multiple active result sets