Microsoft
70-451 · Question #49
70-451 Question #49: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #49. 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 contains a table named Claims. The structure of the Claims table is as shown in the following table. Only two percent of the claims are open at any point in time. You discover that queries on claims that have an Open status take a long time to execute. You need to optimize the performance of the claim-processing queries. What should you do?
Exhibit
Options
- AUse a partitioning function to partition the Claims table on the open_date column.
- BCreate a view for the Claims table by using a WHERE clause to include all rows that have a
- CCreate an index for the Claims table by using a WHERE clause to include all rows that have
- DCreate a table-valued function for the Claims table by using a WHERE clause to include all
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.