nerdexam
Microsoft

DP-300 · Question #474

Drag and Drop Question You have a highly available Azure SQL Managed Instance that contains two servers named Server1 and Server2. Both servers are in the same Azure region. You have a failover group

Sign in or unlock DP-300 to reveal the answer and full explanation for question #474. The question stem and answer options stay visible for context.

Submitted by haruto_sh· Mar 6, 2026Design and implement a high availability and disaster recovery solution for Azure SQL Managed Instance, including cross-region failover group configuration and DNS zone requirements.

Question

Drag and Drop Question You have a highly available Azure SQL Managed Instance that contains two servers named Server1 and Server2. Both servers are in the same Azure region. You have a failover group named FG1 that contains both servers. Server1 is the active server in FG1. You need to change the Azure region of the active server and ensure that the server remains active after the change. You perform a manual failover from Server1 to Server2. Which three actions should you perform in sequence next? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Answer:

Exhibit

DP-300 question #474 exhibit

Answer Area

Drag items

Delete FG1, recreate a failover group that has the same name, and add Server2 and Server3 to the new group.Perform a manual failover from Server2 to Server3.Delete FG1, recreate a failover group that has the same name, and add Server1 and Server3 to the new group.Create a new server named Server3 and add Server3 to the same DNS zone as Server1.Create a new server named Server3 and add Server3 to a different DNS zone than Server1.

Unlock DP-300 to see the answer

You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Azure SQL Managed Instance#Failover Groups#High Availability#Region Migration
Full DP-300 Practice