Microsoft
70-451 · Question #122
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…
The correct answer is B. Build a nonclustered index on the country_id column and use the INCLUDE clause to include. 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. 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.
How the community answered
(33 responses)- A6% (2)
- B79% (26)
- C3% (1)
- D12% (4)
Community Discussion
No community discussion yet for this question.