You have an application that uses SQL Server in an Azure virtual machine (VM) to store data.
If the VM running the primary instance of SQL Server fails:
– The application must automatically begin using a backup copy of the SQL Server data.
– The recovery solution must guarantee that no data is lost.
If the primary datacenter fails:
– There must be a way to manually switch to a secondary data center.
– Some data loss is acceptable.
You create an active datacenter named AD1 and a passive datacenter named PD1. AD1 has two SQL Server instances. PD1 has one SQL Server instance.
You need to implement the replication and failover solutions for the application.
What should you do?
A. In AD1, configure asynchronous replication and automatic failover. In PD1, configure synchronous replication and manual failover from AD1.
B. In AD1, configure synchronous replication and automatic failover. In PD1, configure synchronous replication and manual failover from AD1.
C. In AD1, configure synchronous replication and manual failover. In PD1, configure asynchronous replication and manual failover from AD1.
D. In AD1, configure asynchronous replication and manual failover. In PD1, configure asynchronous replication and manual failover from AD1.
