You use a Microsoft SQL Server 2012 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 T-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the
answer area and arrange them in the correct order.)
Select and Place:
Answer: 
Explanation:
http://msdn.microsoft.com/en-us/library/ms191432.aspx Read all restrictions for indexed views. Also read this useful question:
http://stackoverflow.com/questions/12419330/how-to-create-indexed-view-with-select-distinct-statement-insql-2005
Wrong.
Correct is 2-3-4-5
Sum and Max should have a GROUP BY
5
1
I agree
0
0
This is not a 70-761 question… It is a 70-741 question. I don’t believe that there are any index questions in 70-741. There are however JSON questions instead.
0
0
P.S. for the 70-461 test and 70-761 test have many same topics, you can also refer to the newest 70-461 dumps here:
https://drive.google.com/open?id=0B-ob6L_QjGLpfnJldlZxTklTaHM0akpJUzhja2pETHJOS0owMzd4eVk1UTVNQUpvdlVxVWM
Regards!!!
0
0
BTW, part of the new 98Q 70-761 dumps are available here:
https://drive.google.com/open?id=0B-ob6L_QjGLpaEZzRVFnOE9OenM
Best Regards!
0
0