Microsoft
70-451 · Question #112
70-451 Question #112: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #112. The question stem and answer options stay visible for context.
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.
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.