You are a database administrator for a Microsoft SQL Server 2012 environment.You want to deploy a new application that will scale out the workload to at least five different SQL Server
instances.
You need to ensure that for each copy of the database, users are able to read and write data that will then be
synchronized between all of the database instances.
Which feature should you use?
A.
Database Mirroring
B.
Peer-to-Peer Replication
C.
Log Shipping
D.
Availability Groups
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 as nodes. Built on the foundation of transactional replication, peer-topeer 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 of data.
https://docs.microsoft.com/en-us/sql/relational-databases/replication/transactional/peer-to-peertransactional-replication