You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 instance is managed by you.
The instance is one of three servers, and the three servers are in a peer-to-peer transactional replication
topology. A table named Orders is included by the publication. 200 GB of data across multiple partitions
are contained by the Orders table.
10 GB of data is loaded to the Orders table periodically by a batch process bulk.
A replication strategy should be designed to have latency minimized.
Which action will you perform?
A.
The BULK INSERT command should be minimized in multiple staging tables. And then partitions should be switched into the Orders table.
B.
The Distributor agent should be set to duplicate transactions continually.
C.
The Distributor agent should be set to modify the commit batch threshold.
D.
The Distributor agent should be switched. And then the BULK INSERT command should be utilized in the Orders table. At last, the publication should be reinitialized.