What should you recommend?

You create a stored procedure that retrieves all of the rows from a table named Table1.

You need to recommend a solution to ensure that all of the statements in the stored procedure can be executed if another transaction is modifying rows in Table1 simultaneously.

What should you recommend?
A . Snapshot isolation
B . A database snapshot
C . Filegroups
D . Indexes

View Answer

Answer: A

Explanation:

Once snapshot isolation is enabled, updated row versions for each transaction are maintained in tempdb. A unique transaction sequence number identifies each transaction, and these unique numbers are recorded for each row version.

The transaction works with the most recent row versions having a sequence number before the sequence number of the transaction.

Newer row versions created after the transaction has begun are ignored by the transaction.