PrepAway - Latest Free Exam Questions & Answers

You need to design a replication strategy to minimize latency

You administer a SQL Server 2008 instance. The instance is one of three servers in a

peer-to-peer transactional replication topology. The publication contains a table named
Orders. The Orders table contains 200 GB of data across multiple partitions. A batch
process bulk loads 10 GB of data to the Orders table periodically. You need to design a
replication strategy to minimize latency. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Disable the Distributor agent. Use the BULK INSERT command in the Orders table.
Reinitialize the publication.

B.
Use the BULK INSERT command in multiple staging tables. Switch partitions into the
Orders table.

C.
Configure the Distributor agent to replicate transactions continually.

D.
Configure the Distributor agent to change the commit batch threshold.


Leave a Reply