Multiple choice sql-server

John Doe wants to establish a replication model that will allow three branch offices to update data at the corporate site. Which replication model should John Doe use?

  1. Remote replication

  2. Snapshot replication

  3. Transactional replication

  4. Merge replication
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Merge replication is designed for scenarios where data is modified at multiple sites (like branch offices) and then synchronized. It allows for autonomous changes and handles conflicts when the data is merged back to the publisher.

Keep practicing — related questions