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 master database to a RAID 10 volume.
B. Move the SharePoint databases to a RAID 10 volume.
C. Set the maximum degree of parallelism for SQL Server instances to 0.
D. Move the master database to a RAID 5 volume.