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 five cities. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 server at the main office and a SQL Server at each of the cities. The main office database server will be configured as the Publisher and Distributor whilst the remaining servers are configured as Subscribers who are rarely updated. You ensure that when updates of the subscribers conflicts with the Publisher the Publisher always takes precedence. The connections between the Publisher/Distributor and the Subscribers are periodic and are configured to occur after business hours only. You are required to design a replication configuration that meets the update and conflicts resolution requirements whist you use the least amount of administrative effort. The Publisher and Subscribers are required to remain synchronized with identical data. What should you do?
A. Transactional replication must be configured with queued-updating Subscribers
B. Merge replication must be configured with a custom managed code resolver
C. Merge replication should be configured for manual resolution
D. The Transactional replication should be configured with immediate-updating Subscribers
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 five cities. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 server at the main office and a SQL Server at each of the cities. The main office database server will be configured as the Publisher and Distributor whilst the remaining servers are configured as Subscribers who are rarely updated. You ensure that when updates of the subscribers conflicts with the Publisher the Publisher always takes precedence. The connections between the Publisher/Distributor and the Subscribers are periodic and are configured to occur after business hours only. You are required to design a replication configuration that meets the update and conflicts resolution requirements whist you use the least amount of administrative effort. The Publisher and Subscribers are required to remain synchronized with identical data. What should you do?
A. Transactional replication must be configured with queued-updating Subscribers B. Merge replication must be configured with a custom managed code resolver C. Merge replication should be configured for manual resolution D. The Transactional replication should be configured with immediate-updating Subscribers