What should you recommend?

A company is developing a mission-critical line of business app that uses Azure SQL Database Managed Instance.

You must design a disaster recovery strategy for the solution/

You need to ensure that the database automatically recovers when full or partial loss of the Azure SQL Database service occurs in the primary region.

What should you recommend?
A . Failover-group
B . Azure SQL Data Sync
C . SQL Replication
D . Active geo-replication

View Answer

Answer: A

Explanation:

Auto-failover groups is a SQL Database feature that allows you to manage replication and failover of a group of databases on a SQL Database server or all databases in a Managed Instance to another region (currently in public preview for Managed Instance). It uses the same underlying technology as active geo-­replication. You can initiate failover manually or you can delegate it to the SQL Database service based on a user-defined policy.

Reference: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auto-failover-group