Question
A company wants to deploy a new application that will distribute the workload to five different database instances. The database administrator needs to ensure that, for each copy of the database, users are able to read and write data that will be synchronized across all of the instances.
Which of the following should the administrator use to achieve this objective?
- A. Peer-to-peer replication Correct
- B. Failover clustering
- C. Log shipping
- D. Availability groups
Explanation
Peer-to-peer replication keeps a full copy of the data on every node, and each node can accept reads and writes that are propagated in near real time to all the other nodes, which matches five read/write instances kept in sync. Failover clustering runs one active instance on shared storage, log shipping keeps warm standby copies that are not writable, and availability groups allow writes only on the primary replica with read-only secondaries.
