Microsoft · DP-300
Geo-replication and failover groups
DP-300 · Lesson 21 of 22 · 2:59:59
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: active geo-replication and its readable secondaries, failover groups for databases and managed instances with their listeners, planned and forced failovers, customer-managed and Microsoft-managed failover policies, monitoring replication lag, and using secondaries for reads and as license-free standby replicas. Includes three original practice questions.
Preview the topics
- Contoso’s prescriptions app uses three databases on one logical server, which must move to North Europe together after a regional outage, with no connection string change. What should the team configure?
- During a regional outage, Contoso cannot wait a one-hour grace period before its prescriptions failover group fails over. Which policy should it use?
- Contoso’s DBA sees the replication lag of the North Europe secondary keep growing during month-end loads. What’s the most likely cause, and the fix?