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…

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…

Design and implement a data warehouse

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

How the community answered

(33 responses)

A
3% (1)
B
3% (1)
C
88% (29)
D
6% (2)

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.

Topics

#merge replication#offline synchronization#replication types#publisher subscriber

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice