7. You have asked to implement Disaster Recovery (DR) to your SQL Server
2008 database. In addition to the DR, you are looking into options for using
the DR instance as reporting database. What technology can you implement?
A. Log Shipping
B. Transactional Replication
C. Merge Replication
D. Mirroring
The correct answer is B. Log Shipping and Mirroring can be used for the DR
method but cannot be used as reporting solutions since the database will be
in recovering mode while Log Shipping and Mirroring are in operation.
There is no need for Merge Replication since data will be modified only at
one end. Therefore, Transactional Replication is the answer for this.
Bạn đang xem 7. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P156 PDF