You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a stored procedure which is used as the data source for a report.
However, a Domain.com user named Mia Hamm complains that the data returned by the report
does not comply with normal safety standards. During the investigation you notice that the results
are caused by phantom reads. You need to make sure that the report result does not connect to
the other users at Domain.com.
What should you do?
A.
You should consider making the database Read Committed Snapshot isolation.
B.
You should consider changing the stored procedure to utilize the Snapshot isolation level.
C.
You should consider making the database run an Auto Update Statistics.
D.
You should consider changing the stored procedure to utilize the Read Committed Snapshot isolation level.