Microsoft
70-432 · Question #89
70-432 Question #89: Real Exam Question with Answer & Explanation
The correct answer is D. Reinitialize the publication and immediately generate a new snapshot.. See the full explanation below for the reasoning.
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.
Community Discussion
No community discussion yet for this question.