Microsoft · DP-300
Maintenance, automatic tuning, and IQP
DP-300 · Lesson 14 of 22 · 1:59:10
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-300 exam (Administering Microsoft Azure SQL Solutions). In this lesson: index maintenance based on fragmentation and page density, statistics and DBCC CHECKDB, automatic tuning (force last good plan, create and drop index) and how it validates changes, and intelligent query processing features by compatibility level. Includes three original practice questions.
Preview the topics
- Contoso’s nightly job rebuilds every index of a 2 TB database on a SQL Server VM, and runs past opening hours. Which change follows current guidance?
- Contoso wants Azure SQL Database to create helpful indexes and drop unused ones, with every change checked and reverted if it hurts performance. What should it enable?
- Contoso’s database runs at compatibility level 130, and a procedure is fast for small stores but slow for the biggest ones, depending on the parameter. What could help, without changing code?