SQL Server interview questions: - State publisher, distributor and subscriber in “Replication”?

This is the most expected asked SQL Server interview questions during the interview by the interviewer.

Publisher is the one who owns the database and is the main source for data. Publisher identifies what data should be distributed across.

Distributor is a bridge between publisher and subscriber. Distributor gathers all the published data and holds it until it sends it across to all subscriber. So as it is a bridge who sits in between publisher and subscriber, it supports multiple publisher and subscriber concept.

Subscriber is the end source or the final destination to which data has to be transmitted.

                      Figure: - Publisher, Distributor and Subscriber in action

View video on Query Plan, Logical/Physical operators in SQL Server as follows: -



Click for more SQL Server interview questions

Regards,

Visit for more author’s blog on SQL Server interview questions

SQL Server interview questions: - What are the different types of replication supported by SQL SERVER?

There are three types of replication supported by SQL SERVER:-

(a) Snapshot Replication.

Snapshot Replication takes snapshot of one database and moves it to the other
database. After initial load data can be refreshed periodically. The only
disadvantage of this type of replication is that all data has to be copied each
time the table is refreshed.

(b)Transactional Replication

In transactional replication, data is copied first time as in snapshot
replication, but later only the transactions are synchronized rather than
replicating the whole database. You can either specify to run continuously or on
periodic basis.

(c)Merge Replication.
Merge replication combines data from multiple sources into a single central
database. Again as usual, the initial load is like snapshot but later it allows
change of data both on subscriber and publisher, later when they come on-line it
detects and combines them and updates accordingly.

Also view video on the difference between Unique key and primary key: -




Get our more tutorials on SQL server interview questions

Regards,

View author’s blog on SQL server interview questions

19 importantSQL Server interview questions on replication

This section will cover the most asked SQL Server interview questions by the interviewer so have a look on the following and do revise it when ever you go for the SQL Server interview

Normally SQL Server interview starts with.....
What is the best way to update data between SQL Servers?
What are the scenarios you will need multiple databases with schema?
How will you plan your replication?
What are publisher, distributor and subscriber in “Replication”?
What is “Push” and “Pull” subscription?
Can a publication support push and pull at one time?
What are different models/types of replication?
What is Snapshot replication?
What are the advantages and disadvantages of using Snapshot replication?
What type of data will qualify for “Snapshot replication”?
What is the actual location where the distributor runs?
Can you explain in detail how exactly “Snapshot Replication” works?
What is merge replication?
How does merge replication works?
What are advantages and disadvantages of Merge replication?
What is conflict resolution in Merge replication?
What is a transactional replication?
Can you explain in detail how transactional replication works?
What are data type concerns during replications?

So friends answering to above question on replication of SQL Server interview questions helped me to clear in front of the interviewer.