70-432 · Question #89
You are the administrator of a SQL Server 2008 instance with a database named AdventureWorks. The AdventureWorks database contains the Products table. You create a Merge Replication topology and a…
Sign in or unlock 70-432 to reveal the answer and full explanation for question #89. The question stem and answer options stay visible for context.
Question
You are the administrator of a SQL Server 2008 instance with a database named AdventureWorks. The AdventureWorks database contains the Products table. You create a Merge Replication topology and a Publication to replicate the Products table to the SQL Server instances at remote locations. The Publication has a 21-day retention period. When a user returns from a one-month vacation, she discovers that her database does not contain the most recent data. The Windows Event log states the following error message:
"Replication: expired subscription dropped." You need to obtain the most recent data in the database of the user. You also need to ensure that future data changes are appropriately replicated. What should you do?
Options
- ARecreate the publication.
- BUpload unsynchronized changes.
- CUpload unsynchronized changes, and then reinitialize the publication.
- DReinitialize the publication and immediately generate a new snapshot.
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.