PrepAway - Latest Free Exam Questions & Answers

What should you do 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.
Configure the Distributor agent to replicate transactions continually.

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

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

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


Leave a Reply