You are the administrator for your company’s SharePoint environment.
You are preparing your environment for high availability. You must use SQL Server AlwaysOn.You need to identify the replication methodology for each SharePoint service database.
In the table below, identify whether SQL Server AlwaysOn is available for each of the service databases.
NOTE: Make only one selection in each column.
Hot Area:
Explanation:
Configuration database
Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability – Yes.
Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery – No. This
is a farm specific database.
Central Administration content database
Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability – Yes.
Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery – No. This
is a farm specific database.
Supported high availability and disaster recovery options for SharePoint databases
TestKing: Answer 3-2