DP-300 · Question #13
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?
The correct answer is D. READ_COMMITTED_SNAPSHOT to ON. In SQL Server, you can also minimize locking contention while protecting transactions from dirty reads of uncommitted data modifications using either: - The READ COMMITTED isolation level with the READ_COMMITTED_SNAPSHOT database option set to ON. - The SNAPSHOT isolation…
Question
Options
- APARAMETERIZATION to FORCED
- BPARAMETERIZATION to SIMPLE
- CDelayed Durability to Forced
- DREAD_COMMITTED_SNAPSHOT to ON
How the community answered
(15 responses)- A7% (1)
- B13% (2)
- D80% (12)
Explanation
In SQL Server, you can also minimize locking contention while protecting transactions from dirty reads of uncommitted data modifications using either: - The READ COMMITTED isolation level with the READ_COMMITTED_SNAPSHOT database option set to ON. - The SNAPSHOT isolation level. If READ_COMMITTED_SNAPSHOT is set to ON (the default on SQL Azure Database), the Database Engine uses row versioning to present each statement with a transactionally consistent snapshot of the data as it existed at the start of the statement. Locks are not used to protect the data from updates by other transactions. https://docs.microsoft.com/en-us/sql/t-sql/statements/set-transaction-isolation-level-transact-sql
Community Discussion
No community discussion yet for this question.