12. You are a DBA at an organization with several locations, and each location has
a SQL Server 2008 instance. Employee records from all the locations are at also
at the head office, and each employee record needs to be replicated to each
location. What scalable method can you use to implement this?
A. Implement many publishers and each publisher has a filter with hardcoded
location name.
B. Implement Merge Replication with dynamic filters.
C. Implement this using Peer-to-Peer Replication with dynamic filters.
D. You cannot implement this using replication.
The correct answer is B. Dynamic filters are available only with Merge
Replication. Though you can use many Publishers and subscribers, this is
not a feasible solution because there are several subscribers.
Bạn đang xem 12. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P156 PDF