nerdexam
Microsoft

70-465 · Question #62

You need to recommend a disaster recovery strategy for the Inventory database. What should you include in the recommendation?

The correct answer is A. Log shipping. For disaster recovery of the Inventory database, log shipping is the recommended strategy, providing an asynchronous copy of the database at a secondary server by periodically shipping transaction log backups.

Submitted by lukas.cz· Mar 5, 2026Design and implement database solutions for SQL Server

Question

You need to recommend a disaster recovery strategy for the Inventory database. What should you include in the recommendation?

Options

  • ALog shipping
  • BSQL Server Failover Clustering
  • CAlwaysOn availability groups
  • DPeer-to-peer replication

How the community answered

(18 responses)
  • A
    72% (13)
  • B
    6% (1)
  • C
    6% (1)
  • D
    17% (3)

Why each option

For disaster recovery of the Inventory database, log shipping is the recommended strategy, providing an asynchronous copy of the database at a secondary server by periodically shipping transaction log backups.

ALog shippingCorrect

Log shipping is a straightforward disaster recovery solution that automatically backs up transaction logs from a primary database and restores them to one or more secondary databases on separate servers. It provides geographic redundancy with configurable latency and is ideal when a simple, low-cost DR strategy is needed without the complexity of clustering or availability groups. It also supports a warm standby that can be brought online if the primary fails.

BSQL Server Failover Clustering

SQL Server Failover Clustering is a high-availability solution that protects against server-level failures within a single datacenter using shared storage, but it does not provide geographic disaster recovery since all nodes share the same storage and are typically co-located.

CAlwaysOn availability groups

AlwaysOn Availability Groups provide high availability and disaster recovery but require SQL Server Enterprise Edition and Windows Server Failover Clustering infrastructure, making them more complex and costly than log shipping for a straightforward DR recommendation.

DPeer-to-peer replication

Peer-to-peer replication is designed for scale-out read workloads and multi-master scenarios to distribute data across multiple nodes, not for disaster recovery, as it does not provide a clean failover mechanism or maintain a recoverable standby copy.

Concept tested: SQL Server log shipping for disaster recovery

Source: https://learn.microsoft.com/en-us/sql/database-engine/log-shipping/about-log-shipping-sql-server

Topics

#Disaster recovery#Log shipping#High availability

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice