You are managing a SharePoint farm. The SharePoint databases are configured to run on a dedicated instance of Microsoft
Posted: Mon Oct 17, 2022 4:05 pm
You are managing a SharePoint farm.
The SharePoint databases are configured to run on a dedicated instance of Microsoft SQL Server 2008 R2 Service Pack 1.
You need to optimize query executions.
What should you do?
A. Move the SharePoint databases to a RAID 10 volume.
B. Move the SharePoint databases to a RAID 5 volume.
C. Set the maximum degree of parallelism for SQL Server instances to 4.
D. Set the maximum degree of parallelism for SQL Server instances to 0.
The SharePoint databases are configured to run on a dedicated instance of Microsoft SQL Server 2008 R2 Service Pack 1.
You need to optimize query executions.
What should you do?
A. Move the SharePoint databases to a RAID 10 volume.
B. Move the SharePoint databases to a RAID 5 volume.
C. Set the maximum degree of parallelism for SQL Server instances to 4.
D. Set the maximum degree of parallelism for SQL Server instances to 0.