Microsoft
70-450 · Question #127
70-450 Question #127: Real Exam Question with Answer & Explanation
Sign in or unlock 70-450 to reveal the answer and full explanation for question #127. The question stem and answer options stay visible for context.
Question
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?
Options
- AConfigure the Distributor agent to replicate transactions continually.
- Bmay be the optimal solution. Using the -continuous option on the distributor will ensure that
- CUse the BULK INSERT command in multiple staging tables.
- DDisable the Distributor agent. Use the BULK INSERT command in the Orders table.
Unlock 70-450 to see the answer
You've previewed enough free 70-450 questions. Unlock 70-450 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.