Your company uses SQL Server 2005. You are implementing a series or views that are used in ad hoc queries. The views are used to enrorce your companys security policy or abstracting data. Some or these views perform slowly. You create indexes on those views to increase performance, while still maintaining the companys security policy. One or the views returns the current date as one or the columns. The view returns the current date by using the GETDATE() function. This view does not allow you to create an index. You need to create an index on the view. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A.
Remove all deterministic function calls from within the view.
B.
Remove all nondeterministic function calls from within the view.
C.
Schema-bind all functions that are called from within the view.
D.
Create the view and specify the WITH CHECK OPTION clause.