nerdexam
Exams70-463Questions#126
Microsoft

70-463 · Question #126

70-463 Question #126: Real Exam Question with Answer & Explanation

The correct answer is C: Merge replication.. Merge replication is specifically designed for scenarios where subscribers need to receive data, work offline (making changes independently), and later synchronize those changes back with the Publisher and other Subscribers. It supports bidirectional data flow and conflict resolu

Question

You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are discussing replication type that is used when subscribers need to receive data, make changes offline, and later synchronize changes with the Publisher and other Subscribers. Which of the following is the replication type being discussed?

Options

  • ASnapshot replication.
  • BTransactional replication.
  • CMerge replication.
  • DPeer-to-peer replication

Explanation

Merge replication is specifically designed for scenarios where subscribers need to receive data, work offline (making changes independently), and later synchronize those changes back with the Publisher and other Subscribers. It supports bidirectional data flow and conflict resolution. Snapshot replication simply distributes a point-in-time copy of data. Transactional replication streams committed transactions from Publisher to Subscribers in near real-time but does not natively support offline editing and resync. Peer-to-peer replication is for high-availability scenarios where all nodes are peers, not for offline/sync workflows.

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice