Databases: Oracle, SQL Server, and Data Warehousing

Casual Mode - Take your time!

1 / 10
✓
Correct
0
✗
Incorrect
0
★
Score
0%
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