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.