18. You have implemented replication of a SQL Server database server, but are
concerned about the additional load of having 100 PDAs running SQL Server
Compact Edition subscribing to read-only publications. You have monitored
that there are performance issues in the replication. What step can you take to
improve the performance?
A. Move the Publisher duties to another SQL Server to lessen the load on the
main server.
B. Move the Distributor duties to another SQL Server to lessen the load on
the main server.
C. Move the Subscriber duties to another SQL Server to lessen the load on
D. There is nothing you can do to lower the load if you have that many clients.
The correct answer is B. You can offload the distribution duties to another
server and have all the subscribers connect to the distribution database in the
replication.
Bạn đang xem 18. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P156 PDF