Microsoft
70-451 · Question #58
70-451 Question #58: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #58. The question stem and answer options stay visible for context.
Question
You are a database developer. You plan to design a database solution by using SQL Server 2008. Your company has a main office in New York and several branch offices globally. All the offices use databases on their local SQL Server 2008 servers to support trading applications. A low-bandwidth WAN link connects the offices. The WAN link is subject to interruptions. You plan to implement a reporting instance that will be deployed in the main office. You need to design a solution to transfer data from all offices to the reporting instance in the main office. You also need to ensure that the solution has minimum effect on the performance of all trading servers. What should you do?
Options
- ACreate a warm standby server in the main office by using log shipping from the branch offices.
- BUse distributed transactions in the branch offices to write the trade information to the local
- CCreate a mirrored database solution in high-safety mode in each branch office.
- DCreate a publication by using transactional replication in each branch office.
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 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.