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 ecommerce 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

One Comment on “Which transaction isolation level should you use in sp1?


Leave a Reply