Your company uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce your companys security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance, while still maintaining the companys security policy. One of the views returns the current date as one of 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?（）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.

多项选择题

Your company uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce your companys security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance, while still maintaining the companys security policy. One of the views returns the current date as one of 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?（）

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.

相关考题

单项选择题 You work with a SQL Server 2005 database that provides banking information for customers. You want customers to see banking reports that combine data that is retrieved from the database with real-time investment information that comes from a Web service provided by a third party. The investment information must be current when the reports are executed. You need to create the appropriate objects that support the reports. What should you do?（）

多项选择题 Your company uses a SQL Server 2005 database. This database contains a trigger named trg_InsertOrders, which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal?（）

单项选择题 YouarecreatingaSQLServer2005databaseforamortgagecompany.ThedatabasewillsupportanewWeb-basedapplicationthatwillhandleupto1,000simultaneoususers.Thisapplicationmustquicklydisplaytheresultsofcalculation-intensiveoperations,suchascalculatingmortgagepaymentsandamortizationschedules.Youneedtoensurethatthedatabaseprocessescalculationsasquicklyandefficientlyaspossible.Whatshouldyoudo?（）

备案号：湘ICP备14005140号-3

经营许可证号：湘B2-20140064

MCITP(70-431)