What should you include in the recommendation?

You need to recommend a disaster recovery strategy for the Inventory database.

What should you include in the recommendation?

A. Log shipping

B. SQL Server Failover Clustering

C. AlwaysOn availability groups

D. Peer-to-peer replication

View Answer

Answer: A

Explanation:

* Scenario:

/ You must be able to recover data from the Inventory database if a storage failure occurs. You have a Recovery Point Objective (RPO) of one hour.

/ A. Datum Corporation has offices in Miami and Montreal.

* SQL Server Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the secondary databases individually.