Question No: 15
You administer a SQL Server 2008 instance. You need to configure the instance to use a single thread for queries that have an estimated execution cost less than 3. Which sp_configure configuration option should you set?
A. priority boost
B. precompute rank
C. max worker threads
D. query governor cost limit
E. cost threshold for parallelism
Answer: E
70-432 Exam Dumps