Which is the correct answer?

You are managing a SQL Server 2008 instance which contains a stored procedure which is
utilized as the data source for a report which is implemented during business hours for
Company.com. A user called Clerk tells you that the data returned by the report is not safety.
You find out that the results are caused by phantom reads. You should make sure that the report
returns results without connecting with other users. Which is the correct answer?

You are managing a SQL Server 2008 instance which contains a stored procedure which is
utilized as the data source for a report which is implemented during business hours for
Company.com. A user called Clerk tells you that the data returned by the report is not safety.
You find out that the results are caused by phantom reads. You should make sure that the report
returns results without connecting with other users. Which is the correct answer?

A.
You should make the database Read Committed Snapshot isolation

B.
You should make the database Auto Update Statistics

C.
You should change the stored procedure to utilize the Snapshot isolation level.

D.
You should change the stored procedure to utilize the Read Committed Snapshot isolation level.



Leave a Reply 0

Your email address will not be published. Required fields are marked *