nerdexam
CompTIA

SK0-004 · Question #850

A server technician is setting up replication for a database server. The technician is designing a server that is fully redundant and highly available. Which of the following replication strategies…

The correct answer is A. Mirroring. Database mirroring provides synchronous, real-time replication to a standby server, delivering the full redundancy and high availability the scenario requires.

Security and disaster recovery

Question

A server technician is setting up replication for a database server. The technician is designing a server that is fully redundant and highly available. Which of the following replication strategies should be used?

Options

  • AMirroring
  • BLog shipping
  • CDisk-to-disk
  • DServer-to-server

How the community answered

(48 responses)
  • A
    71% (34)
  • B
    4% (2)
  • C
    8% (4)
  • D
    17% (8)

Why each option

Database mirroring provides synchronous, real-time replication to a standby server, delivering the full redundancy and high availability the scenario requires.

AMirroringCorrect

Database mirroring in synchronous (high-safety) mode commits every transaction to both the principal and mirror server before acknowledging success, ensuring zero data loss and immediate automated failover capability. This architecture makes the standby fully redundant and continuously in sync, satisfying both the full redundancy and high availability requirements stated in the scenario.

BLog shipping

Log shipping asynchronously copies transaction log backups on a scheduled interval, introducing a time lag that means the secondary is never fully synchronized and cannot provide true zero-RPO high availability.

CDisk-to-disk

Disk-to-disk replication is a backup and restore strategy focused on data protection and recovery, not on maintaining a live, continuously available secondary database instance.

DServer-to-server

Server-to-server is not a defined database replication strategy - it describes a generic network topology and does not specify any mechanism that ensures synchronization, redundancy, or high availability.

Concept tested: Synchronous database mirroring for high availability

Source: https://learn.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-sql-server

Topics

#database replication#high availability#mirroring#redundancy

Community Discussion

No community discussion yet for this question.

Full SK0-004 Practice