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?
A.
READ COMMITTED
B.
REPEATABLE READ
C.
READ COMMITTED SNAPSHOT
D.
READ UNCOMMITTED