You work as the network database administrator at MiracleInfocom .com. The MiracleInfocom .com network consists of a single Active Directory domain named MiracleInfocom .com. All servers on the MiracleInfocom .com network run Microsoft Windows Server 2003 and the database server runs Microsoft SQL Server 2005. The MiracleInfocom .com network users use a database called Billventory. You need to replicate the Billventory database across all the servers and you are concerned with the distribution database growing very large. You are required to minimize the size of the distribution database and you want o increase the frequency that delivered transactions from the distribution database are deleted. You must accomplish your goal using the least amount of administrative effort. What should you do?
A. A new job should be created that automatically delete the replicated Agent history
B. The Replication agents checkup job should be configured to run more frequently
C. The Expired subscriptions cleanup job must be configured to run twice a day
D. The frequency that the Agent History clean up job runs should be increased
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. All servers on the MiracleInfocom .com network run Microsoft Windows Server 2003 and the database server runs Microsoft SQL Server 2005. The MiracleInfocom .com network users use a database called Billventory. You need to replicate the Billventory database across all the servers and you are concerned with the distribution database growing very large. You are required to minimize the size of the distribution database and you want o increase the frequency that delivered transactions from the distribution database are deleted. You must accomplish your goal using the least amount of administrative effort. What should you do?
A. A new job should be created that automatically delete the replicated Agent history B. The Replication agents checkup job should be configured to run more frequently C. The Expired subscriptions cleanup job must be configured to run twice a day D. The frequency that the Agent History clean up job runs should be increased