70-451 · Question #54
You are a database developer. You plan to design a database solution by using SQL Server 2008. The database supports a warehousing application and contains data from two warehouses in a table named…
The correct answer is D. Create a plan guide that uses the OPTIMIZE FOR clause for Warehouse A. See the full explanation below for the reasoning.
Question
You are a database developer. You plan to design a database solution by using SQL Server 2008. The database supports a warehousing application and contains data from two warehouses in a table named Product. The Product table contains a warehouse indicator field named warehouse_id. The two Warehouse B contains 55,000 items. The solution uses a third-party application that runs on SQL Server 2008. The application uses a stored procedure that returns the warehouse inventory based on the warehouse_id parameter. Users report that occasionally, the system performance is unacceptable when the Warehouse A inventory is queried. You cannot modify the stored procedures in the application. You need to ensure acceptable performance when users query the inventory of Warehouse A. What should you do?
Options
- ACreate a clustered index on the warehouse_id column.
- BCreate a nonclustered index on the warehouse_id column.
- CCreate a plan guide that sets the MAXDOP query hint to 1.
- DCreate a plan guide that uses the OPTIMIZE FOR clause for Warehouse A.
How the community answered
(28 responses)- A14% (4)
- B4% (1)
- C7% (2)
- D75% (21)
Community Discussion
No community discussion yet for this question.