19 important SQL Server interview questions on replication
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.