MS SQL Server - 71 - Replication Types and Models MCQ

71 – Replication Types and Models MCQ

1 / 25

1. In SQL Server replication, what role does a Publisher play?

Distributes replicated data

Stores all replicated data

Subscribes to replicated data

Publishes data changes to subscribers

2 / 25

2. What is a Subscriber in SQL Server replication?

The server that receives and applies replicated data changes

The server that stores all replicated data

The server that publishes data changes

The server that distributes replicated data

3 / 25

3. In SQL Server replication, what is a Distributor?

The server that distributes replicated data

The server that publishes data changes

The server that receives and applies replicated data changes

The server that stores all replicated data

4 / 25

4. What is the purpose of the distribution database in SQL Server replication?

To temporarily store replicated data and metadata

To store all replicated data

To manage replication agents

To store a copy of the publisher's data

5 / 25

5. What role does the distribution database play in SQL Server replication?

It manages replication agents.

It temporarily stores replicated data and metadata.

It permanently stores replicated data.

It stores a copy of the publisher's data.

6 / 25

6. In SQL Server replication, what are publications?

A type of replication model

The process of subscribing to data changes

The act of distributing replicated data

A collection of articles

7 / 25

7. What is an article in SQL Server replication?

A subscriber to replicated data

A distribution agent

A single unit of data to be replicated

A collection of publications

8 / 25

8. Which SQL Server replication agent is responsible for distributing data changes to subscribers?

Log Reader Agent

Snapshot Agent

Distribution Agent

Merge Agent

9 / 25

9. In SQL Server replication, what is the Snapshot Agent responsible for?

Merging data changes from multiple sources

Taking point-in-time snapshots of data

Distributing data changes to subscribers

Capturing data changes at the publisher

10 / 25

10. What is the primary function of the Log Reader Agent in SQL Server replication?

Capturing data changes at the publisher

Distributing data changes to subscribers

Taking snapshots of data

Merging data changes from multiple sources

11 / 25

11. In SQL Server replication, what is the purpose of the Merge Agent?

Merging data changes from multiple sources

Distributing data changes to subscribers

Taking snapshots of data

Capturing data changes at the publisher

12 / 25

12. What is the most suitable replication type for scenarios where data consistency and near real-time updates are essential?

Peer-to-Peer replication

Transactional replication

Snapshot replication

Merge replication

13 / 25

13. In SQL Server replication, which replication type is suitable for scenarios where the entire dataset changes infrequently?

Snapshot replication

Peer-to-Peer replication

Merge replication

Transactional replication

14 / 25

14. What is Peer-to-Peer replication in SQL Server?

A replication model where there is no need for distribution databases

A replication model where each server is a subscriber and publisher

A replication model with only one publisher and many subscribers

A replication model for real-time data updates

15 / 25

15. In SQL Server replication, which replication type is used for scenarios where multiple servers need to collaborate and share data changes?

Snapshot replication

Peer-to-Peer replication

Transactional replication

Merge replication

16 / 25

16. What is Bi-directional transactional replication in SQL Server?

A replication model where data flows in one direction only

A replication model with only one subscriber

A replication model where data flows in both directions

A replication model that doesn't use distribution databases

17 / 25

17. In SQL Server replication, which replication type is used for scenarios where data conflicts need to be resolved?

Transactional replication

Snapshot replication

Peer-to-Peer replication

Merge replication

18 / 25

18. What is a replication model in SQL Server?

A type of replication agent

A set of rules governing how data is replicated

A type of replication type

A type of distribution database

19 / 25

19. In SQL Server replication, what is the primary purpose of a replication model?

To define the roles of publishers and subscribers

To specify the data to be replicated

To determine the replication type

To govern how data changes are replicated and resolved

20 / 25

20. Which replication model in SQL Server allows for conflict resolution using conflict tables?

Snapshot replication

Peer-to-Peer replication

Merge replication

Transactional replication

21 / 25

21. In SQL Server replication, which replication model is based on taking point-in-time snapshots of data?

Transactional replication

Snapshot replication

Peer-to-Peer replication

Merge replication

22 / 25

22. What is the primary advantage of Peer-to-Peer replication in SQL Server?

It allows for many-to-one replication scenarios.

It ensures data consistency without conflict resolution.

It minimizes data distribution delays.

It enables multiple servers to collaborate and share data changes.

23 / 25

23. In SQL Server replication, which replication type is suitable for scenarios where data changes need to be tracked in real-time?

Snapshot replication

Merge replication

Peer-to-Peer replication

Transactional replication

24 / 25

24. What is the main role of the Transactional replication type in SQL Server?

Taking snapshots of data

Sharing data changes among multiple servers

Merging data changes from multiple sources

Distributing data changes to subscribers in real-time

25 / 25

25. In SQL Server replication, which replication type is suitable for scenarios where data changes frequently and need to be distributed in near real-time?

Merge replication

Snapshot replication

Peer-to-Peer replication

Transactional replication

Your score is

MS SQL Server – 71 – Replication Types and Models MCQ