You work as the network database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. The MiracleInfocom .com network has its headquarters in Chicago and branch offices in Miami, Dallas and Detroit. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 server in each office. The database server in the main office is the Publisher and Distributor for merge replication. The network database server in the branch offices are configured as Subscribers and the Subscriptions are configured as pull subscriptions. During the course of the day you configure merge replication because the connection between the offices is intermittent and the data at the Subscribers rarely changes. You want to resolve conflicts manually when they occur. You are required to ensure that the SQL Server does not automatically resolve conflicts whilst you identify how you would resolve the conflicts that occur. What should you do?
A. The Interactive Resolver should be used to resolve replication conflicts
B. The conflict tracking level should be configured for row level
C. The Conflict Viewer should be used to resolve replication conflicts
D. All subscriptions should be configures as push subscriptions
Answer:A
You work as the network database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. The MiracleInfocom .com network has its headquarters in Chicago and branch offices in Miami, Dallas and Detroit. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 server in each office. The database server in the main office is the Publisher and Distributor for merge replication. The network database server in the branch offices are configured as Subscribers and the Subscriptions are configured as pull subscriptions. During the course of the day you configure merge replication because the connection between the offices is intermittent and the data at the Subscribers rarely changes. You want to resolve conflicts manually when they occur. You are required to ensure that the SQL Server does not automatically resolve conflicts whilst you identify how you would resolve the conflicts that occur. What should you do?
A. The Interactive Resolver should be used to resolve replication conflicts B. The conflict tracking level should be configured for row level C. The Conflict Viewer should be used to resolve replication conflicts D. All subscriptions should be configures as push subscriptions