Multiple choice technology databases

You want to create a replication strategy that will allow users in four branch offices to have a fresh copy of data from the database in the central office every day at 5 a.m. for their daily reports. Although there are many changes to the data during the course of a day, the entire publication is not that large. Which replication strategy should you use in SQL Server?

  1. Transactional replication

  2. Peer-to-peer replication

  3. Merge replication

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

Snapshot replication is ideal for this scenario because it delivers a complete data copy daily at 5am, matching the reporting requirement. Transactional replication is continuous, peer-to-peer is for multi-master scenarios, and merge replication handles conflict resolution - all unnecessary for this daily batch refresh pattern.

Keep practicing — related questions