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
https://blogs.msdn.microsoft.com/sql_pfe_blog/2013/06/15/an-overview-of-high-availability-and-disaster-recovery-solutions-available-for-sql-server/