Your company has regional sales offices in Hyderabad, Noida and Chennai. You need to implement the replication scenario which will support autonomous changes the replicated data on the Publisher and on the Subscriber with the priority-based conflict resolution. Which type of SQL Server replication should you implement?
A. Transaction replication
B. Merge replication
C. Transaction replication with immediate-updating subscribers
D. Snapshot replication
Answer:B
Your company has regional sales offices in Hyderabad, Noida and Chennai. You need to implement the replication scenario which will support autonomous changes the replicated data on the Publisher and on the Subscriber with the priority-based conflict resolution. Which type of SQL Server replication should you implement?
A. Transaction replication B. Merge replication C. Transaction replication with immediate-updating subscribers D. Snapshot replication