Home » Microsoft » 70-765 » Does the solution meet the goal?
You manage a Microsoft SQL Server environment with several databases.
You need to ensure that queries use statistical data and do not initialize values for local variables.
Solution: you set the value of the MAXDOP parameter to 2.
Does the solution meet the goal?
A. Yes
B. No
Correct Answer: B
Explanation/Reference:
Explanation:
When an instance of SQL Server runs on a computer that has more than one microprocessor or CPU, it detects the best degree of parallelism, that is, the number of processors employed to run a single statement, for each parallel plan execution. You can use the max degree of parallelism (MAXDOP) option to limit the number of processors to use in parallel plan execution.
References: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option? view=sql-server-2017