Microsoft
70-433 · Question #88
You have a database server that has four quad-core processors. This database server executes complex queries that are used to generate reports. You need to force a query to use only one processor…
The correct answer is B. OPTION (MAXDOP 1). See the full explanation below for the reasoning.
Question
You have a database server that has four quad-core processors. This database server executes complex queries that are used to generate reports. You need to force a query to use only one processor core without affecting other queries. Which option should you use?
Options
- AOPTION (FAST 1)
- BOPTION (MAXDOP 1)
- COPTION (RECOMPILE)
- DOPTION (MAXRECURSION 1)
How the community answered
(44 responses)- A9% (4)
- B82% (36)
- C7% (3)
- D2% (1)
Community Discussion
No community discussion yet for this question.