Exam 70-461 topic 1 question 99 discussion

DRAG DROP -
You use a Microsoft SQL Server database.
You need to create an indexed view within the database for a report that displays Customer Name and the total revenue for that customer.
Which four Transact-SQL segments should you use to develop the solution? (To answer, move the appropriate Transact-SQL segments from the list of Transact-
SQL segments to the answer area and arrange them in the correct order.)
Select and Place:

Suggested Answer:
References:
http://msdn.microsoft.com/en-us/library/ms191432.aspx
http://stackoverflow.com/questions/12419330/how-to-create-indexed-view-with-select-distinct-statement-insql-2005