Microsoft Exam Questions

You have been instructed to make sure that while the stored procedure executes, other transactions a

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com stores information consumed by ABC.com’s e-commerce application via SQL
Azure.
You have generated a stored procedure, which is employed to read and modify the value of all the
goods offered on ABC.com’s e-commerce site. You have been instructed to make sure that while
the stored procedure executes, other transactions are prevented from updating goods information.

A.
You should consider setting the transaction isolation level of the stored procedure to Read
committed.

B.
You should consider setting the transaction isolation level of the stored procedure to
Repeatable read.

C.
You should consider setting the transaction isolation level of the stored procedure to Read
uncommitted.

D.
You should consider setting the transaction isolation level of the stored procedure to
Serializable.

Explanation: