📚 Practice Mode

Databases: Oracle, SQL Server, and Data Warehousing

Learn at your own pace with hints and detailed explanations

1 / 10
Multiple Choice

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?

  1. Transactional replication
  2. Peer-to-peer replication
  3. Merge replication
  4. Snapshot replication
Change Mode