Get Complete Q&A from 70-383 Exam Questions

70-383 | You are managing a SharePoint farm…

Question: 3

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.

Answer: A

Leave a Reply