MS SQL Server - 72 - Managing Replication MCQ

72 – Managing Replication MCQ

1 / 25

1. What is the primary responsibility of managing replication in SQL Server?

Configuring database mirroring

Creating backup copies of databases

Installing SQL Server on multiple servers

Ensuring data consistency between publisher and subscribers

2 / 25

2. In SQL Server replication, what is the primary role of a distributor?

Publishing data changes

Managing SQL Server Agent jobs

Distributing data changes to subscribers

Storing backup copies of data

3 / 25

3. What is a publication server in SQL Server replication?

The server responsible for distributing data changes to subscribers

The server that initiates the replication process

The server that receives replicated data

The server responsible for storing backup copies of data

4 / 25

4. In SQL Server replication, what is the primary function of a publication?

To store backup copies of data

To distribute data changes to subscribers

To capture data changes at the publisher

To manage replication agents

5 / 25

5. What is a subscription server in SQL Server replication?

The server that initiates the replication process

The server responsible for distributing data changes to subscribers

The server that receives replicated data

The server responsible for storing backup copies of data

6 / 25

6. In SQL Server replication, what is the purpose of setting up publications?

To manage replication agents

To store backup copies of data

To capture data changes at the publisher

To distribute data changes to subscribers

7 / 25

7. What is the primary responsibility of configuring the distribution server in SQL Server replication?

Storing backup copies of data

Managing replication agents

Distributing data changes to subscribers

Initiating the replication process

8 / 25

8. In SQL Server replication, what is a publication type?

A type of replication model

A collection of articles

A type of distribution database

A type of replication agent

9 / 25

9. What is the primary purpose of configuring subscription servers in SQL Server replication?

To capture data changes at the publisher

To distribute data changes to subscribers

To store backup copies of data

To manage replication agents

10 / 25

10. In SQL Server replication, what is a subscription type?

A server that receives replicated data

A type of replication agent

A type of distribution database

A type of replication model

11 / 25

11. In SQL Server replication, what is the purpose of configuring the distribution database?

To distribute data changes to subscribers

To store backup copies of data

To manage replication agents

To capture data changes at the publisher

12 / 25

12. What is the primary function of a replication agent in SQL Server replication?

To manage replication publications

To capture data changes at the publisher

To distribute data changes to subscribers

To store backup copies of data

13 / 25

13. In SQL Server replication, what is a snapshot publication?

A type of distribution database

A subscription type

A publication that captures a point-in-time snapshot of data

A type of replication agent

14 / 25

14. What is the primary benefit of using transactional publications in SQL Server replication?

Capturing point-in-time snapshots of data

Resolving data conflicts automatically

Enabling peer-to-peer replication

Minimizing data distribution delays

15 / 25

15. In SQL Server replication, what is a peer-to-peer publication?

A publication with only one publisher and many subscribers

A publication for capturing real-time data updates

A publication that allows multiple servers to collaborate and share data changes

A publication that captures point-in-time snapshots of data

16 / 25

16. What is the primary advantage of using bi-directional transactional replication in SQL Server?

Data flows in both directions

Data flows from many subscribers to one publisher

Data distribution delays are minimized

Data flows in one direction only

17 / 25

17. In SQL Server replication, what is the primary benefit of using merge publications?

Point-in-time snapshots of data are captured

Conflicts can be resolved using conflict tables

Multiple servers collaborate and share data changes

Data distribution delays are minimized

18 / 25

18. What is a conflict table in SQL Server replication?

A table that stores backup copies of data

A table used to track data distribution delays

A table used to resolve data conflicts in merge replication

A table used for managing replication agents

19 / 25

19. In SQL Server replication, what is the primary advantage of using snapshot publications?

Enabling peer-to-peer replication

Automatically resolving data conflicts

Minimizing data distribution delays

Capturing point-in-time snapshots of data

20 / 25

20. In SQL Server replication, what is a transactional publication?

A publication that captures point-in-time snapshots of data

A publication with only one publisher and many subscribers

A publication for capturing real-time data updates

A publication that allows multiple servers to collaborate and share data changes

21 / 25

21. What is the primary advantage of using peer-to-peer replication in SQL Server?

Capturing point-in-time snapshots of data

Minimizing data distribution delays

Automatically resolving data conflicts

Allowing multiple servers to collaborate and share data changes

22 / 25

22. In SQL Server replication, what is a merge publication?

A publication that captures point-in-time snapshots of data

A publication that allows multiple servers to collaborate and share data changes

A publication with only one publisher and many subscribers

A publication for capturing real-time data updates

23 / 25

23. What is the primary benefit of using transactional publications in SQL Server replication?

Conflicts can be resolved using conflict tables

Data distribution delays are minimized

Multiple servers collaborate and share data changes

Point-in-time snapshots of data are captured

24 / 25

24. In SQL Server replication, what is a bi-directional transactional publication?

A publication where data flows in both directions

A publication that allows multiple servers to collaborate and share data changes

A publication where data flows in one direction only

A publication that captures point-in-time snapshots of data

25 / 25

25. What is the primary benefit of using snapshot publications in SQL Server replication?

Automatically resolving data conflicts

Enabling peer-to-peer replication

Minimizing data distribution delays

Capturing point-in-time snapshots of data

Your score is

MS SQL Server – 72 – Managing Replication MCQ