DP-300 Certification Practice Question #166

Question

You deploy a database to an Azure SQL Database managed instance.
You need to prevent read queries from blocking queries that are trying to write to the database.
Which database option should set?

Accepted Answer

To prevent read queries (which require shared locks under standard Read Committed isolation) from blocking write queries (which require exclusive locks), you should enable Read Committed Snapshot Isolation (RCSI) by setting the database option `READ_COMMITTED_SNAPSHOT` to `ON` (Option D). Under RCSI, read operations use row versioning to retrieve a transactionally consistent snapshot of the data as of the start of the query, requiring no shared locks and thus never blocking write operations. The other options are incorrect because Parameterization (Options A and B) and Delayed Durability (Option C) are unrelated to concurrency locking.

More DP-300 practice questions