nerdexam
Microsoft

70-465 · Question #60

Drag and Drop Question You need to recommend which statement should be used to update SalesOrder. How should you recommend completing the statement? To answer, drag the appropriate elements to the…

The correct answer is TRANSACTION; ISOLATION; SNAPSHOT; TRANSACTION. The correct statement uses BEGIN TRANSACTION, SET TRANSACTION ISOLATION LEVEL SNAPSHOT, and COMMIT TRANSACTION to safely update SalesOrder. SNAPSHOT isolation level allows readers to see a consistent snapshot of data as it existed at the start of the transaction, preventing…

Submitted by yasin.bd· Mar 5, 2026Implement transactions and concurrency control in Azure SQL Database / SQL Server - specifically selecting appropriate isolation levels to balance data consistency and performance for DML operations.

Question

Drag and Drop Question You need to recommend which statement should be used to update SalesOrder. How should you recommend completing the statement? To answer, drag the appropriate elements to the correct locations. Each element may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. Answer:

Exhibit

70-465 question #60 exhibit

Answer Area

Drag items

EXPLICITISOLATIONREAD UNCOMMITTEDROLLBACKSERIALIZABLESNAPSHOTTABLOCKTRANSACTION

Correct arrangement

  • TRANSACTION
  • ISOLATION
  • SNAPSHOT
  • TRANSACTION

Explanation

The correct statement uses BEGIN TRANSACTION, SET TRANSACTION ISOLATION LEVEL SNAPSHOT, and COMMIT TRANSACTION to safely update SalesOrder. SNAPSHOT isolation level allows readers to see a consistent snapshot of data as it existed at the start of the transaction, preventing dirty reads and blocking issues without holding shared locks. This is the recommended pattern in Azure SQL / SQL Server when you need optimistic concurrency control - reads don't block writes and writes don't block reads, making it ideal for high-concurrency update scenarios like SalesOrder.

Topics

#Transaction Isolation Levels#SNAPSHOT Isolation#Concurrency Control#T-SQL DML

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-465 Practice