ExamGecko
Question list
Search
Search

Question 19 - DS0-001 discussion

Report
Export

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
Answers
A.
[Peer-to-peer replication
B.
Failover clustering
Answers
B.
Failover clustering
C.
Log shipping
Answers
C.
Log shipping
D.
Availability groups
Answers
D.
Availability groups
Suggested 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.

asked 02/10/2024
Amirouche Rahani
48 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first