Microsoft
70-451 · Question #54
70-451 Question #54: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #54. The question stem and answer options stay visible for context.
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.
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.