Microsoft
70-451 · Question #112
You have a line-of-business application. The application generates reports based on data from database views. Users report that it takes a long time to generate reports. You run a SQL Server…
The correct answer is A. Change the isolation level of the database. See the full explanation below for the reasoning.
Question
You have a line-of-business application. The application generates reports based on data from database views. Users report that it takes a long time to generate reports. You run a SQL Server Profiler trace and discover that the application is generating many blocking processes. You need to minimize the number of blocking processes. You must achieve this goal without modifying the statements that the application sends to the server. What should you do?
Options
- AChange the isolation level of the database.
- BImplement a database Service Broker.
- CCreate new database report views.
- DChange the isolation level of each query.
How the community answered
(20 responses)- A80% (16)
- C5% (1)
- D15% (3)
Community Discussion
No community discussion yet for this question.