What should you include in the recommendation?

You need to recommend a disaster recovery solution for an on-premises Microsoft SQL Server database.

The solution must meet the following requirements:

• Support real-time data replication to a different geographic region.

• Use Azure as a disaster recovery target.

• Minimize costs and administrative effort.

What should you include in the recommendation?
A . database mirroring on an instance of SQL Server on Azure Virtual Machines
B. availability groups for SQL Server on Azure Virtual Machines
C. an Azure SQL Managed Instance link
D. transactional replication to an Azure SQL Managed Instance

View Answer

Answer: D