You administer a SQL Server 2008 infrastructure. The infrastructure contains SQL Server
2008 servers across four sites. All sites are connected via a WAN link. All sites use the
same database application. Your company has the following business requirements: All
sites maintain data related to their site. Each site has access to data related to other sites.
In the event of any site failure, database activity is redirected to another site. You need to
implement a replication topology that meets the business requirements. Which solution
should you implement?
A.
Snapshot replication
B.
Peer-to-Peer replication
C.
Transactional replication that uses updating subscriptions
D.
HTTP Merge replication