PrepAway - Latest Free Exam Questions & Answers

Which transaction isolation level should you use in sp1?

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

You develop a stored procedure named sp1. Sp1 is used to read the price of all the products
sold on the e-commerce site.
You need to ensure that sp1 can read data even while another transaction is modifying the
price of a product. Sp1 must only read committed data.
Which transaction isolation level should you use in sp1?

PrepAway - Latest Free Exam Questions & Answers

A.
Serializable

B.
Snapshot

C.
Repeatable read

D.
Read committed


Leave a Reply