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 copies the entire set of data at a specific moment in time. Since the entire publication is not very large, the branch offices only need a daily update at 5 a.m., and transaction-by-transaction synchronization is not required, Snapshot replication is the most appropriate and simplest strategy.

Keep practicing — related questions