Microsoft
70-450 · Question #83
70-450 Question #83: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #83. The question stem and answer options stay visible for context.
Question
You are the administrator of a SQL Server 2008, with a report often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You have to make sure that consistent data is returned by the report while not affecting other users. Which action should you perform to achieve this goal?
Options
- AYou should configure the database for Read Committed Snapshot isolation.
- BYou should modify the stored procedure to use the Snapshot isolation level
- CYou should configure the database for Auto Update Statistics asynchronously
- DYou should modify the stored procedure to use the Repeatable Read isolation level
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 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.