Valid 70-331 Dumps shared by ExamDiscuss.com for Helping Passing 70-331 Exam! ExamDiscuss.com now offer the newest 70-331 exam dumps, the ExamDiscuss.com 70-331 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-331 dumps with Test Engine here:
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?
Correct Answer: C
Explanation/Reference: Explanation: Set max degree of parallelism (MAXDOP) to 1 for instances of SQL Server that host SharePoint databases to make sure that a single SQL Server process serves each request. Important: Setting the max degree of parallelism to any other number can cause a less optimal query plan to be used that will decrease SharePoint Server 2013 performance. References: http://technet.microsoft.com/en-us/library/hh292622(v=office.15).aspx