PrepAway - Latest Free Exam Questions & Answers

Which isolation level should you set to ON?

You have a table that contains 10 million rows. You need to design a query that returns a
100,000- row sample dataset. The solution must minimize the query’s execution time. The
sample may contain inconsistent data. Which isolation level should you set to ON?

PrepAway - Latest Free Exam Questions & Answers

A.
READ COMMITTED

B.
REPEATABLE READ

C.
READ COMMITTED SNAPSHOT

D.
READ UNCOMMITTED


Leave a Reply