Microsoft
70-451 · Question #62
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…
The correct answer is D. READ UNCOMMITTED. See the full explanation below for the reasoning.
Question
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?
Options
- AREAD COMMITTED SNAPSHOT
- BREAD COMMITTED
- CREPEATABLE READ
- DREAD UNCOMMITTED
How the community answered
(34 responses)- A18% (6)
- B9% (3)
- C3% (1)
- D71% (24)
Community Discussion
No community discussion yet for this question.