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