Microsoft
70-451 · Question #63
70-451 Question #63: Real Exam Question with Answer & Explanation
The correct answer is A. READ COMMITTED. See the full explanation below for the reasoning.
Question
You are a database developer. You design a database solution by using SQL Server 2008. Your company has offices in Europe, Asia, North America, and Africa. The company data is updated for each region after business hours. The queries used by reports on the database are blocked when the data is being updated. Occasionally, the data is updated simultaneously for the Africa and Europe regions. You need to ensure maximum concurrency for the database by using minimum possible system resources. Which isolation level should you use?
Options
- AREAD COMMITTED
- BREPEATABLE READ
- CSNAPSHOT
- DSERIALIZABLE
Community Discussion
No community discussion yet for this question.