Microsoft · DP-800
Configuration and concurrency
DP-800 · Lesson 11 of 20 · 1:19:30
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-800 exam (Microsoft Certified: SQL AI Developer Associate). In this lesson: vCore and DTU, service tiers, serverless, MAXDOP and other settings, transaction isolation levels with row versioning and optimized locking, finding and preventing blocking, and capturing and preventing deadlocks. Includes three original practice questions.
Preview the topics
- A finance report runs three queries in one transaction, and all three must see the data as of the transaction’s start, without blocking updates. Which isolation level fits?
- Dozens of sessions are blocked by session 52, which is sleeping, with a transaction left open after an application timeout. What should the team do now, and change for next time?
- Two procedures regularly deadlock: one updates Orders, then Inventory, and the other updates Inventory, then Orders. What prevents the cycle?