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.
HTTP Merge replication
C.
Peer-to-Peer replication
D.
Transactional replication that uses updating subscriptions