Which of the following should the administrator use to achieve this objective?

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
B . Failover clustering
C . Log shipping
D . Availability groups

View Answer

Answer: A

Explanation:

The administrator should use peer-to-peer replication to achieve this objective. Peer-to-peer replication is a type of replication that allows data to be distributed across multiple database instances that are equal partners, or peers. Each peer can read and write data that will be synchronized across all peers. This provides high availability, scalability, and load balancing for the application. The other options are either not suitable for this scenario or do not support bidirectional data synchronization. For example, failover clustering provides high availability but does not distribute the workload across multiple instances; log shipping provides disaster recovery but does not allow writing data to secondary instances; availability groups provide high availability and read-only access to secondary replicas but do not support peer-to-peer replication.

Reference: CompTIA DataSys+ Course Outline, Domain 5.0 Business Continuity, Objective 5.3 Given a scenario, implement replication of database management systems.