Microsoft
70-451 · Question #104
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…
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.
How the community answered
(19 responses)- A5% (1)
- B84% (16)
- C5% (1)
- D5% (1)
Community Discussion
No community discussion yet for this question.