Microsoft
70-457 · Question #63
You use Microsoft SQL Server 2012 to write code for a transaction that contains several statements. There is high contention between readers and writers on several tables used by your transaction…
The correct answer is C. Create a user-defined type on the model database. See the full explanation below for the reasoning.
Question
You use Microsoft SQL Server 2012 to write code for a transaction that contains several statements. There is high contention between readers and writers on several tables used by your transaction. You need to minimize the use of the tempdb space. You also need to prevent reading queries from blocking writing queries. Which isolation level should you use?
Options
- ACreate a user-defined type on the master database.
- BCreate a user-defined data type on the model database.
- CCreate a user-defined type on the model database.
- DCreate a user-defined data type on the master database.
How the community answered
(46 responses)- A9% (4)
- B4% (2)
- C70% (32)
- D17% (8)
Community Discussion
No community discussion yet for this question.