You are planning the deployment of a SharePoint Server 2013 server farm. You plan to deploy Microsoft SQL Server 2012 AlwaysOn Availability Groups. The groups will have four replicas configured as…

The correct commit types for each SQL replica are: SQLReplica2 should use 'Synchronous commit'. SQLReplica3 should use 'Asynchronous commit'. SQLReplica4 should use 'Asynchronous commit'.

Plan business continuity management

Question

You are planning the deployment of a SharePoint Server 2013 server farm. You plan to deploy Microsoft SQL Server 2012 AlwaysOn Availability Groups. The groups will have four replicas configured as shown in the following table. You need to determine which mode of commit must be used for each replica. Which commit type should you recommend for each replica? (To answer, select the appropriate options in the answer area.)
SQLReplica name | Replica configuration
SQLReplica1 | SQLReplica1 is the primary replica.
SQLReplica2 | SQLReplica2 is used for high-availability and is installed in the same data center as SQLReplica1.
SQLReplica3 | SQLReplica3 is used for disaster recovery purposes and is installed in a remote location.
SQLReplica4 | SQLReplica4 is used for reporting purpose. Failure of this replica must not affect the SharePoint Server 2013 deployment.

Explanation

The correct commit types for each SQL replica are: SQLReplica2 should use 'Synchronous commit'. SQLReplica3 should use 'Asynchronous commit'. SQLReplica4 should use 'Asynchronous commit'.

Topics

#AlwaysOn Availability Groups#synchronous commit#asynchronous commit#SQL Server 2012

Community Discussion

No community discussion yet for this question.

Full 70-332 Practice