QuestionQ128

VerifiedDatabase Deployment

A company plans to deploy a new application that will distribute its workload across five different database instances. The database administrator must ensure that, for every database copy, users can read and write data that is synchronized across all instances.

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

Explanation

Peer-to-peer replication allows inserts, updates, and deletes at any node in the topology and propagates those changes to the other nodes, maintaining synchronized database copies. Write operations for the same row should be partitioned to avoid replication conflicts.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!