Microsoft
70-519 · Question #287
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…
The correct answer is B. Use SQL Server replication. See the full explanation below for the reasoning.
Question
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?
Options
- AUse the application cache
- BUse SQL Server replication
- CUse network load balancing
- DUse multiple active result sets
How the community answered
(21 responses)- A5% (1)
- B81% (17)
- C10% (2)
- D5% (1)
Community Discussion
No community discussion yet for this question.