You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com has its headquarters in Washington and five field offices in the city. All servers on the Domain.com network run Windows Server 2003, all database servers run SQL Server 2005 and all client computers run Windows XP Professional. The Domain.com network contains a database server named Certkiller -DB01 that is located at headquarters. Certkiller -DB01 hosts a database named CK_Repairs.
Domain.com users in the Purchasing department order parts that technicians use to repair customer’s computers at customer sites. The parts are shipped to the field offices. At present Domain.com tracks the usage of parts through data entered on the customer’s invoice. Each field office has a client computer that runs SQL Server 2005 Standard Edition that is used to capture invoice data. Domain.com wants to implement a new inventory tracking application for the parts. The new application will access a table named _Parts in the CK_Repairs database. You need to enable users at headquarters and at the various field offices to update the _Parts table. You decide to implement merge replication with CERTKILLER-DB01 as the Publisher and the SQL Server 2005 Standard Edition computers at the field offices as the subscribers.
To minimize the usage of disk space on the Subscribers, you need to ensure that only the Publisher is used to store conflict records.
What should you do?
A.
Run the sp_addmergepublication stored procedure with the @conflict_logging argument on Certkiller -DB01.
B.
Run the sp_addmergesubscription stored procedure with the @publication argument on Certkiller -DB01.
C.
Run the sp_addmergepublication stored procedure with the @centralized_conflicts argument on Certkiller -DB01.
D.
Run the sp_addmergesubscription stored procedure with the @centralized_conflicts argument on Certkiller -DB01.
Explanation:
The @conflict_logging = ‘publisher’ argument of the sp_addmergepublication stored procedure specifies that conflict records should be stored only on the Publisher.
Incorrect Answers:
A, D: When sp_addmergesubscription is run on the Publisher, it is used to register a subscriber. The sp_addmergesubscription stored procedure does not define the placement of the conflict records.
C: The centralized_conflicts = ‘true’ argument of the sp_addmergepublication stored procedure specifies that conflict records should be stored only on the Publisher. However, this argument is supported for backward compatibility with SQL Server 2000. The @conflict_logging = ‘publisher’ argument is the preferred argument for SQL Server 2005.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: sp_addmergepublication Microsoft SQL Server 2005 Books Online (2006), Index: sp_addmergesubscription