You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which is one of three servers in a peer-to-peer transactional replication topology. The publication has a table called SRB which contains 220 GB of data across multiple partitions. Regularly 12 GB of data is loaded to the SRB tableby a batch process. You have to reduce the latency by developing a replication strategy. So what should you do?
A.
You should configure the Distributor agent to change the commit batch threshold.
B.
You should configure the Distributor agent to replicate transactions continually.
C.
You should use the BULK INSERT command in multiple staging tables and switch partitions into the SRB table.
D.
You should disable the Distributor agent and use the BULK INSERT command in the SRB table. Reinitialize the publication.