Microsoft
70-451 · Question #122
70-451 Question #122: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #122. 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. A database contains a table named Customer. The structure of the Customer table is as shown in the following table. The solution uses the following stored procedure to return customer details. Users report that the stored procedure takes a long time to execute. You need to optimize the performance of the stored procedure. What should you do?
Exhibit
Options
- ARecreate the primary key as a nonclustered unique index and build a clustered index on the
- BBuild a nonclustered index on the country_id column and use the INCLUDE clause to include
- CBuild a nonclustered index on the country_id, customer_name, and customer_id columns.
- DBuild a nonclustered index only on the country_id column.
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.