Microsoft
70-451 · Question #49
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…
The correct answer is C. Create an index for the Claims table by using a WHERE clause to include all rows that have. 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. 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
How the community answered
(58 responses)- A9% (5)
- B3% (2)
- C71% (41)
- D17% (10)
Community Discussion
No community discussion yet for this question.