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.
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)- A71% (34)
- B4% (2)
- C8% (4)
- D17% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.