What should you do to ensure that the information changes are properly doubled ?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. The database contains a Products table.
You have developed a Merge Replication topology and a Publication which owns a 25-day
retention period; so that the Products table can be reproduce to the SQL Server instances at
remote locations. After a one month break the Domain.com user named Mia Hamm, noticed that
CK_Prod does not include her latest data. During the investigation you came upon the following
error message: "Replication: expired subscription dropped."

Mia Hamm needs the latest data in her database and you should ensure that the information
changes are properly doubled.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. The database contains a Products table.
You have developed a Merge Replication topology and a Publication which owns a 25-day
retention period; so that the Products table can be reproduce to the SQL Server instances at
remote locations. After a one month break the Domain.com user named Mia Hamm, noticed that
CK_Prod does not include her latest data. During the investigation you came upon the following
error message: “Replication: expired subscription dropped.”

Mia Hamm needs the latest data in her database and you should ensure that the information
changes are properly doubled.

What should you do?

A.
You should consider uploading synchronized changes.

B.
You should consider reinitializing the publication and produce a new snapshot immediately.

C.
You should consider uploading unsynchronized changes and reinitializing the publication.

D.
You should consider uploading unsynchronized changes.



Leave a Reply 0

Your email address will not be published. Required fields are marked *