Microsoft
70-457 · Question #59
You develop a Microsoft SQL Server 2012 database. You create a view that performs the following tasks: - Joins 8 tables that contain up to 500,000 records each. - Performs aggregations on 5 fields…
The correct answer is C. Convert the view into an indexed view. See the full explanation below for the reasoning.
Question
You develop a Microsoft SQL Server 2012 database. You create a view that performs the following tasks:
- Joins 8 tables that contain up to 500,000 records each.
- Performs aggregations on 5 fields.
The view is frequently used in several reports. You need to improve the performance of the reports. What should you do?
Options
- AConvert the view into a table-valued function.
- BConvert the view into a Common Table Expression (CTE).
- CConvert the view into an indexed view.
- DConvert the view into a stored procedure and retrieve the result from the stored procedure into a
How the community answered
(29 responses)- A10% (3)
- B3% (1)
- C69% (20)
- D17% (5)
Community Discussion
No community discussion yet for this question.