Microsoft
70-451 · Question #42
70-451 Question #42: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #42. 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 application has a table named Transactions that contains millions of rows. The table has multiple columns that include transaction_id and transaction_date. There is a clustered index on the transaction_id column. There is a nonclustered index on the transaction_date column. You discover that the following query takes a long time to execute. You need to ensure that the query retrieves data in minimum possible time. What should you do?
Exhibit
Options
- ACreate a nonclustered index on the transaction_type_id column.
- BCreate a nonclustered index on the transaction_date and transaction_type_id columns.
- CCreate a nonclustered index on the transaction_date column and include the
- DCreate a nonclustered index on the transaction_date and transaction_type_id columns and
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.