Microsoft
70-432 · Question #64
70-432 Question #64: Real Exam Question with Answer & Explanation
The correct answer is B. You should modify the stored procedure to use the Snapshot isolation level. See the full explanation below for the reasoning.
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
Community Discussion
No community discussion yet for this question.