Home » Microsoft » 70-465 » 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
Correct Answer: A
Explanation/Reference:
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.
Reference: About Log Shipping (SQL Server)
