Interview Questions

1. What are the advantages and disadvantages of Snapshot replication over Transactional replication.

Snapshot Replication would be good to use if:

1. if you are sure that you would synchronize only once in a day and your business requirements do not include replicating transactions as and when they are comitted on the publisher

2. If the size of the replicating articles is small – may be a few MBs/GBs

3. If it is does not matter that for some time the replicating articles would be locked (till the snapshot would be generated)

Transactional Replication would be good to use if:

1. You want incremental changes to be propagated to Subscribers as they occur.

2. The application requires low latency between the time changes are made at the Publisher and the changes arrive at the Subscriber.

3. The application requires access to intermediate data states. For example, if a row changes five times, transactional replication allows an application to respond to each change (such as firing a trigger), not simply the net data change to the row.

4.The Publisher has a very high volume of insert, update, and delete activity.

By Hena Parveen 2 0
Is this helpful? Yes No

Submit an interview question

Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.

Get Started

Comments

Leave a Comment


Check out more interview questions

Based on your skills

MS SQL Server

1658748 1720 23 859

Angular

42392 92 0 46

Wordpress

34278 72 1 36