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 a branch office in Miami The MiracleInfocom .com network contains two Microsoft SQL Server servers named MiracleInfocom -SR01 in the main office running SQL Server 2005 configured as the Publisher and MiracleInfocom -SR02 at the branch office running SQL 2000 configured as the Distributor. The MiracleInfocom .com network uses transactional replication with queued updating subscribers to synchronize data between locations. You define the following publications on MiracleInfocom -SR01: 1. FinancialData 2. FinancialStatusData Since MiracleInfocom -SR02 acts as the distributor most subscriptions are implemented as push subscriptions. You monitor the replication and discover that changes are not always replicated to the stores because of connection timeouts and you need to resolve the problem. What should you do?
A. The QueryTimeout value should be increased in the Log Reader Agent profile
B. The PollingInterval should be decreased for each Distribution Agent
C. The PollingInterval value should be decreased in the Queue Reader Agent profile
D. The LoginTimeout value should be increased in the Distribution Agent profile
Answer:D
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 a branch office in Miami The MiracleInfocom .com network contains two Microsoft SQL Server servers named MiracleInfocom -SR01 in the main office running SQL Server 2005 configured as the Publisher and MiracleInfocom -SR02 at the branch office running SQL 2000 configured as the Distributor. The MiracleInfocom .com network uses transactional replication with queued updating subscribers to synchronize data between locations. You define the following publications on MiracleInfocom -SR01: 1. FinancialData 2. FinancialStatusData Since MiracleInfocom -SR02 acts as the distributor most subscriptions are implemented as push subscriptions. You monitor the replication and discover that changes are not always replicated to the stores because of connection timeouts and you need to resolve the problem. What should you do?
A. The QueryTimeout value should be increased in the Log Reader Agent profile B. The PollingInterval should be decreased for each Distribution Agent C. The PollingInterval value should be decreased in the Queue Reader Agent profile D. The LoginTimeout value should be increased in the Distribution Agent profile