70-450 · Question #24
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…
The correct answer is C. Peer-to-Peer replication. Peer-to-peer replication provides a scale-out and high-availability solution by maintaining copies of data across multiple server instances, also referred to asnodes. Built on the foundation of transactional replication, peer-to-peer replication propagates transactionally…
Question
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?
Options
- ASnapshot replication
- BHTTP Merge replication
- CPeer-to-Peer replication
- DTransactional replication that uses updating subscriptions
How the community answered
(50 responses)- A4% (2)
- B16% (8)
- C72% (36)
- D8% (4)
Explanation
Peer-to-peer replication provides a scale-out and high-availability solution by maintaining copies of data across multiple server instances, also referred to asnodes. Built on the foundation of transactional replication, peer-to-peer replication propagates transactionally consistent changes in near real-time. This enables applications that require scale-out of read operations to distribute the reads from clients across multiple nodes. Because data is maintained across the nodes in near real-time, peer-to-peer replication provides data redundancy, which increases the availability
Topics
Community Discussion
No community discussion yet for this question.