Microsoft · DP-300
Availability groups, failover clusters, and log shipping
DP-300 · Lesson 22 of 22 · 3:06:55
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: Always On availability groups on Azure virtual machines (synchronous and asynchronous commit, listeners, distributed network names, and load balancers), what Managed Instance uses instead, failover cluster instances with Azure shared disks or Storage Spaces Direct, log shipping, and monitoring and troubleshooting HA/DR. Includes three original practice questions.
Preview the topics
- Contoso deploys a two-replica availability group on SQL Server VMs in one subnet, and clients cannot reach the listener after a failover. What does a single-subnet deployment need?
- A vendor application on SQL Server VMs needs its SQL Server Agent jobs and logins to fail over with the instance, and supports one copy of the data on shared storage. What fits?
- In Contoso’s availability group, a secondary shows NOT SYNCHRONIZING, and its log send queue keeps growing. Which view should the DBA query first?