Microsoft · DP-300
Deploying Azure SQL and hybrid SQL Server
DP-300 · Lesson 2 of 22 · 12:42
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: automated deployment with ARM templates, Bicep, PowerShell, and the Azure CLI, what each offering needs first (a logical server, a dedicated delegated subnet, a Marketplace image with the SQL IaaS Agent extension), SQL Server enabled by Azure Arc and the Managed Instance link, and patching with Azure Update Manager now that Automated Patching is being retired. Includes three original practice questions.
Preview the topics
- Contoso wants every new environment to get the same logical server, elastic pool, and databases, deployed from source control, with a preview of each change before it applies. What should the team use?
- Contoso runs SQL Server 2022 on premises for its prescriptions database. It wants a disaster recovery copy in Azure, with near real-time replication, and the ability to fail over to Azure and back. What should it set up?
- Contoso’s SQL Server VMs use Automated Patching, but never get SQL Server cumulative updates. The team wants them installed automatically, with a tool that is still supported after 2027. What should it do?