What should you include in the recommendation?

You need to recommend a disaster recovery solution for the back-end tier of the payment processing system.

What should you include in the recommendation?
A . Always On Failover Cluster Instances
B . Azure Site Recovery
C . an auto-failover group
D . geo-redundant database backups

View Answer

Answer: C

Explanation:

Scenario:

– The back-end data store is implemented as a Microsoft SQL Server 2014 database.

– If a data center fails, ensure that the payment processing system remains available without any administrative intervention.

Note: 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. It is a declarative abstraction on top of the existing active geo-replication feature, designed to simplify deployment and management of geo-replicated databases at scale.

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