YOU HAVE ASKED TO IMPLEMENT DISASTER RECOVERY (DR) TO YOUR SQL SERV...

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.