70-519 · Question #265
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…
The correct answer is B. Use AJAX to retrieve the database information D. Use a service that proxies the database queries and caches the results. See the full explanation below for the reasoning.
Question
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 and display 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.)
Options
- AUse SQL Server replication
- BUse AJAX to retrieve the database information
- CUse a control that retrieves and displays the database information
- DUse a service that proxies the database queries and caches the results
How the community answered
(29 responses)- A10% (3)
- B83% (24)
- C7% (2)
Community Discussion
No community discussion yet for this question.