Share article SQL Server interview questions: - How will you explain publisher, distributor and subscriber in “Replication”?: This is the most expected ask ...
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
Visit for more author’s blog on SQL Server interview questions
MVC Interview questions and answers
WCF Interview questions videos
C# Interview Questions & Answers Article
C# design pattern (UNIT of Work Design Pattern)
C# design pattern interview questions – What is Dependency injection ?
C# interview questions and answers: - What is the difference between “==” and .Equals()?
.NET INTERVIEW QUESTIONS & ANSWERS ARTICLE
WPF INTERVIEW QUESTIONS & ANSWERS ARTICLE