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 and Dallas. The MiracleInfocom .com network uses a database called Billventory. The network branch offices are connected to the main office via a high speed Wide Area Network (WAN) connection. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 server in each branch office. The changes on each database in the branch offices should be replicated to the database in the main office and all the tables used in replication have a unique primary key. During the course of the day you implement transactional replication between the SQL servers in the branch offices and the main office. You are required to be notified when the amount of time for a transaction to be committed as the publisher and committed at the Subscriber exceeds a timeout specified in the design document that has been provided. What should you do?
A. A replication alert must be configured to generate an e-mail message
B. A warning should be enabled on the Publisher an specify the appropriate subscription expiration threshold based on the design document value
C. The Replication: agent success predefined replication alert should be enabled on the Publisher
D. A warning should be enabled on the Publisher and set the appropriate threshold for synchronization time based on the design document value
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 and Dallas. The MiracleInfocom .com network uses a database called Billventory. The network branch offices are connected to the main office via a high speed Wide Area Network (WAN) connection. The MiracleInfocom .com network contains a Microsoft SQL Server 2005 server in each branch office. The changes on each database in the branch offices should be replicated to the database in the main office and all the tables used in replication have a unique primary key. During the course of the day you implement transactional replication between the SQL servers in the branch offices and the main office. You are required to be notified when the amount of time for a transaction to be committed as the publisher and committed at the Subscriber exceeds a timeout specified in the design document that has been provided. What should you do?
A. A replication alert must be configured to generate an e-mail message B. A warning should be enabled on the Publisher an specify the appropriate subscription expiration threshold based on the design document value C. The Replication: agent success predefined replication alert should be enabled on the Publisher D. A warning should be enabled on the Publisher and set the appropriate threshold for synchronization time based on the design document value