You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows
Server 2012 servers running SQL Server 2012.
A database named CorpDB1 has many tables containing historical data about customers,
products and sales. CorpDB1 is 200GB in size.
You plan to create a view to display information from multiple tables in CorpDB1. To improve
query performance, you want to ensure that the view is indexed.
How can you ensure that the view is indexed?
A.
By specifying the VIEW_METADATA keyword when you create the view.
B.
By specifying the SCHEMABINDING keyword when you create the view.
C.
By specifying the ENCRYPTION keyword when you create the view.
D.
By specifying the DEFAULT keyword when you create the view.
E.
By specifying the CHECK OPTION keywords when you create the view.
Explanation: