You are employed as an administrator at ABC.com. ABC.com makes use of Microsoft SharePoint
Server 2013 in their environment.
You have previously configured a dedicated instance of Microsoft SQL Server 2008 R2 SP1 to
host ABC.com’s SharePoint databases. You have subsequently been instructed to make sure that
query executions are suitably enhanced.
Which of the following actions should you take?
A.
You should consider making sure that the maximum degree of parallelism for SQL Server
instances is set to 3.
B.
You should consider making sure that the maximum degree of parallelism for SQL Server
instances is set to 2.
C.
You should consider making sure that the maximum degree of parallelism for SQL Server
instances is set to 1.
D.
You should consider making sure that the maximum degree of parallelism for SQL Server
instances is set to 0.
Explanation:
I think the correct answer is C?
http://technet.microsoft.com/en-us/library/hh292622(v=office.15).aspx
Correct answer IS C.
Yes, C is definitely the correct answer. Under no circumstance are you ever recommended to use another option.