Which option should you use?

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?
A. OPTION (MAXDOP 4)
B. OPTION (MAXDOP 0)
C. OPTION (MAXDOP 16)
D. OPTION (MAXDOP 1)

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.