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.
https://technet.microsoft.com/en-us/library/hh292622.aspx
For best performance, use a RAID 10 array for the drive that stores tempdb data files. The number of tempdb data files should equal the number of CPU cores, and each tempdb data file should be set to the same size
I believe confirms the answer is A – Move the SharePoint databases to a RAID 10 Volume