Which feature should you use?

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?

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

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

Scotty

Scotty

B is correct. Key to this is ‘Scale out’ in the question.

Reply

Slazenjer_m

Slazenjer_m

KEYWORD: Read-Write synchronization: Peer-to-Peer Replication

“…users are able to read and write data that will then be synchronized between all of the database instances”.

Reply

Vivek

Vivek

In Peer-to-Peer users of different secondaries can write in Merge they cannot.

Reply