Multiple choice technology databases

What are the different types of Replication?

  1. Transactional

  2. Snapshot

  3. Mirroring

  4. Merge
Reveal answer Fill a bubble to check yourself
A,B,D Correct answer
Explanation

SQL Server supports three main replication types: Transactional replication (changes propagated immediately), Snapshot replication (periodic full data refresh), and Merge replication (bi-directional, allows autonomous changes). Mirroring is a high-availability technology, not a replication method.

AI explanation

Correct answers: Transactional, Snapshot, and Merge replication. These are the three classic SQL Server replication types: Snapshot replication copies the entire dataset at a point in time; Transactional replication continuously propagates incremental changes from a publisher to subscribers; Merge replication allows changes at multiple nodes with conflict resolution. Mirroring is correctly excluded — database mirroring is a separate high-availability/disaster-recovery feature, not a type of replication.

Keep practicing — related questions