You are the database administrator of a SQL Server 2012 database infrastructure at ABC.com.
You need to optimize a very large database table that contains several million rows of data by
designing a view based on the table. The view must allow users to perform aggregations on
several columns.
How should you configure the view to ensure optimal performance?
A.
You should create the view as an indexed view.
B.
You should create a clustered index on the view.
C.
You should make use of a stored procedure to return that data.
D.
You should make use of a table-valued function.
Explanation:
A) It is not possible to create a view as indexed view: you must create the view and then create a clustered index over it.
So the correct response is B).
B is correct.
A is not entirely incorrect. When you create a clustered index on a view, it becomes an indexed view. But if I have to choose between the two, I’ll pick B as correct.
I think A is correct.
A view + index is called “indexed view” ( https://msdn.microsoft.com/en-us/library/ms191432(v=sql.110).aspx )
But answer B says create “a” clustered index, but one index can’t ensure optimal performance, you might need more then one. Answer A means create one (or more) index on a view.
The true is: two question A and B are correct
I think that is a stupid question…
B) The view not exist yet, so we can’t create a index in that
A) Only we create a clustered index that view will be “indexed view”
This is so so so stupid
I mean, what is the goal of this question?
To make us all confuse and find this dumps is not reliable