单项选择题
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?（）
A. Publish the data in the database as an XML Web service by using the FOR XML AUTO clause.
B. Create a table to store the banking information for each customer. Create a trigger that fires when data is inserted into the table that joins with the data coming from the Web service.
C. Create a Transact-SQL stored procedure that uses a temporary table to store the banking information for each customer. Update the table with the values from the Web service.
D. Have a developer in your company create an assembly that calls the remote Web service. Create aCLR function by using the assembly. Call the CLR function and combine the results with banking information in the database.
相关考题
-
多项选择题
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?（）
A. ALTER TABLE OrdersDISABLE TRIGGER trg_InsertOrders
B. DROP TRIGGER trg_InsertOrders
C. DISABLE TRIGGER trg_InsertOrders ON Orders
D. ALTER TRIGGER trg_InsertOrders ON Orders NOT FOR REPLICATION
E. sp_settriggerorder@triggername= 'trg_InsertOrders', @order='None' -
单项选择题
YouarecreatingaSQLServer2005databaseforamortgagecompany.ThedatabasewillsupportanewWeb-basedapplicationthatwillhandleupto1,000simultaneoususers.Thisapplicationmustquicklydisplaytheresultsofcalculation-intensiveoperations,suchascalculatingmortgagepaymentsandamortizationschedules.Youneedtoensurethatthedatabaseprocessescalculationsasquicklyandefficientlyaspossible.Whatshouldyoudo?（）
A. Implement parameterized Transact-SQL queries in the application.
B. Implement Transact-SQL stored procedures in the database.
C. Implement CLR stored procedures in the database.
D. Implement distributed Web services. -
多项选择题
YourcompanyWebsiteincludesapagethatcustomersusetosendfeedbackaboutthecompanyanditsproducts.YouuseaSQLServer2005databasetostorethecommentsintheCommentscolumnofatablenamedFeedback.Youneedtoimplementfull-textsearchingsothatyoucanrunreportsonthecomments.Whichtwoactionsshouldyouperform?（）
A. Create a nonclustered index on the Comments column.
B. Execute the USE Master Transact-SQL statement.
C. Create a full-text catalog.
D. Create a full-text index on the Comments column.
