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 four branch offices. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 server in the main office and one in each branch office. The main office SQL server is configured to act as the Publisher and Distributor for transactional replication. The network branch offices are all configured as subscribers and all subscriptions are configured as push subscriptions. The Data is treated as read-only at the remote offices. You are required to validate connections between the Distributor and the Subscribers and measure the replication latency whilst you collect statistics about latency that is accurate as possible. What should you do?
A. The Replication Monitor must be used to insert tracer tokens and gather token statistics from the Publisher/Distributor and all subscribers
B. The Replication Monitor should be used to set a latency threshold and generate an alert if latency exceeds the threshold
C. The Replication Monitor should be used to view the Queue Reader agent history statistics
D. The Replication Monitor should be used to view Current Average Performance and Current Worst Performance statistics
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 four branch offices. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 server in the main office and one in each branch office. The main office SQL server is configured to act as the Publisher and Distributor for transactional replication. The network branch offices are all configured as subscribers and all subscriptions are configured as push subscriptions. The Data is treated as read-only at the remote offices. You are required to validate connections between the Distributor and the Subscribers and measure the replication latency whilst you collect statistics about latency that is accurate as possible. What should you do?
A. The Replication Monitor must be used to insert tracer tokens and gather token statistics from the Publisher/Distributor and all subscribers B. The Replication Monitor should be used to set a latency threshold and generate an alert if latency exceeds the threshold C. The Replication Monitor should be used to view the Queue Reader agent history statistics D. The Replication Monitor should be used to view Current Average Performance and Current Worst Performance statistics