70-451 · Question #58
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…
The correct answer is D. Create a publication by using transactional replication in each branch office. See the full explanation below for the reasoning.
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.
How the community answered
(14 responses)- B14% (2)
- C7% (1)
- D79% (11)
Community Discussion
No community discussion yet for this question.