- All Exams Instant Download
What should you do?
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?
A . Convert the view into a table-valued function.
B . Convert the view into a Common Table Expression (CTE).
C . Convert the view into an indexed view.
D . Convert the view into a stored procedure and retrieve the result from the stored procedure into a temporary table.
Answer: C
Explanation:
Reference: http://msdn.microsoft.com/en-us/library/ms191432.aspx
Latest 70-461 Dumps Valid Version with 232 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Subscribe
Login
0 Comments
Inline Feedbacks
View all comments