Which transaction isolation level should you use in sp1?

You use SQL Azure to store data used by an e-commerce application.

You develop a stored procedure named sp1.

Sp1 is used to read and change the price of all the products sold on the e-commerce site.

You need to ensure that other transactions are blocked from updating product data while sp1 is executing.

Which transaction isolation level should you use in sp1?
A . read committed
B . repeatable read
C . snapshot
D . serializable

Answer: D

Latest 70-764 Dumps Valid Version with 451 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments