70-450 · Question #26
You administer SQL Server 2008 instances at three site. All sites share a mission-critical database. The business requirements specify that users at each site must be able to perform the following…
The correct answer is B. Peer-to-Peer replication. To minimize latency, users need a local copy of the database. Failover clustering doesn't provide multiple copies. Database mirroring only supports one destination. Database mirroring and log shipping leave the secondary or secondaries in a restoring state, so data is not…
Question
You administer SQL Server 2008 instances at three site. All sites share a mission-critical database. The business requirements specify that users at each site must be able to perform the following tasks:
- Access and modify data on all sites with minimal latency.
- Minimize data loss in the event of a server failure.
You need to provide a high-availability solution that meets the business requirements. Which solution should you implement?
Options
- AFailover clustering
- BPeer-to-Peer replication
- CAsynchronous database mirroring without a witness server
- DLog shipping to servers at two of the sites to provide read-only copies of data
How the community answered
(19 responses)- A5% (1)
- B68% (13)
- C21% (4)
- D5% (1)
Explanation
To minimize latency, users need a local copy of the database. Failover clustering doesn't provide multiple copies. Database mirroring only supports one destination. Database mirroring and log shipping leave the secondary or secondaries in a restoring state, so data is not easily accessible. Peer-to-peer replication is the only viable solution.
Topics
Community Discussion
No community discussion yet for this question.