Microsoft
70-451 · Question #104
70-451 Question #104: Real Exam Question with Answer & Explanation
The correct answer is B. Create an indexed view in which each aggregate function is computed.. See the full explanation below for the reasoning.
Question
You have a server that runs SQL Server 2008 Enterprise. You have a query that contains SUM, AVG, and MAX functions. You discover that the query takes a long time to execute. You need to reduce the amount of time required to execute the query. What should you do?
Options
- AAdd computed columns that have persisted values to the table that contains the aggregate
- BCreate an indexed view in which each aggregate function is computed.
- CAdd computed columns to the table that contains the aggregate values on a per row basis.
- DCreate a view in which each aggregate function is computed.
Community Discussion
No community discussion yet for this question.