nerdexam
Microsoft

DP-300 · Question #434

You have an on-premises Microsoft SQL Server 2022 instance named SQL1. You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1. You need to configure a bidirectional…

The correct answer is D. the Managed Instance link. Disaster recovery with Managed Instance link - Azure SQL Managed Instance You can configure a hybrid disaster recovery solution between SQL Server hosted anywhere and Azure SQL Managed Instance by using the Managed Instance link. With SQL Server 2022, either SQL Server or Azure…

Submitted by yuki_2020· Mar 6, 2026Plan and configure a high availability and disaster recovery (HA/DR) environment

Question

You have an on-premises Microsoft SQL Server 2022 instance named SQL1. You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1. You need to configure a bidirectional disaster recovery solution between SQL1 and SQLMI1. What should you include in the solution?

Options

  • AAzure Database Migration Service
  • BLog Replay Service (LRS)
  • Ca failover group
  • Dthe Managed Instance link

How the community answered

(22 responses)
  • A
    5% (1)
  • B
    18% (4)
  • C
    5% (1)
  • D
    73% (16)

Explanation

Disaster recovery with Managed Instance link - Azure SQL Managed Instance You can configure a hybrid disaster recovery solution between SQL Server hosted anywhere and Azure SQL Managed Instance by using the Managed Instance link. With SQL Server 2022, either SQL Server or Azure SQL Managed Instance can be the primary and you can establish the link initially from either SQL Server or SQL Managed Instance. You can fail over between SQL Server and Azure SQL Managed Instance in either direction, as needed. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link- disaster-recovery

Topics

#Managed Instance link#bidirectional DR#hybrid disaster recovery#SQL Server 2022

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice