Administering Relational Databases on Microsoft Azure — Question 35

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?

Answer options

• 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

Correct answer: D

Explanation

The correct answer is D, as transactional replication allows for real-time data replication to Azure SQL Managed Instance while minimizing costs and administrative overhead. Options A and B involve more complex setups and higher costs, and option C does not provide the necessary real-time replication capabilities.