🎴 Flashcard Mode
Databases: Oracle, SQL Server, and Data Warehousing
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?
Snapshot replication is ideal for this scenario because it distributes a complete copy of the publication at scheduled intervals (daily 5 a.m.). The publication is not large, and while there are many changes during the day, snapshot replication completely refreshes subscriber data each time. Transactional and merge replication are more complex and unnecessary for this daily refresh requirement.