Administering a SQL Database Infrastructure — Question 221

You are a database administrator for a Microsoft SQL Server 2016 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?

Answer options

Correct answer: B

Explanation

Peer-to-Peer Replication allows for multiple SQL Server instances to read and write data independently while maintaining synchronization between them, making it suitable for your requirement of at least five instances. Database Mirroring focuses on failover rather than multi-instance scalability, Log Shipping is primarily for disaster recovery and does not support write operations on multiple databases, and Availability Groups are designed for high availability but may not support the same level of write scalability as Peer-to-Peer Replication.