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…

The correct answer is A. Snapshot isolation. 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…

Submitted by katya_ua· Mar 5, 2026Design and implement database solutions for SQL Server

Question

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?

Options

ASnapshot isolation
BA database snapshot
CFilegroups
DIndexes

How the community answered

(49 responses)

A
71% (35)
B
16% (8)
C
8% (4)
D
4% (2)

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.

Topics

#Snapshot isolation#Database concurrency#Transaction isolation

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice