单项选择题

A.one that uses an internal SQL Server Web service endp……

You are designing the loan application process for the customer terminals. You need to design a Transact-SQL stored procedure that fulfills the business and technical requirements.
Which type of Transact-SQL stored procedure should you use?（）

A.one that uses an internal SQL Server Web service endpoint
B.one that runs a SQL Server Integration Services （SSIS） package
C.one that uses Service Broker
D.one that runs a user-defined function

<上一题目录下一题>

热门试题

多项选择题YouneedtoensurethatthestoredprocedurethatinsertsnewloanrequestscanaccessdataintablesthatarestoredinanotherdatabaseonthesameSQLServerinstance.Whichtwoactionsshouldyouperform?（）

A.Ensure that the stored procedure and the tables are owned by users that are associated with the same SQL Server login.
B.Ensure that the stored procedure and the tables are owned by the same database user.
C.Ensure that the stored procedure and the tables use the same database schema.
D.Configure the multiuser database option on both databases.
E.Configure the cross-database ownership chaining option on both databases.

单项选择题YouneedtodesignthestorageoftheapplicationtextsforUIelementstofulfilltherequirements.Whichtableandcolumndesignshouldyouuse?（）

A.Languages (LanguageID, Name)Elements (ElementID, Description)ElementLanguages (ElementID, LanguageID, Text)
B.Languages (LanguageID, Name)Elements (ElementID, LanguageID, Description, Text)
C.Languages (LanguageID, Name)ElementTexts (LanguageID, Text)ElementDescriptions (ElementID, Description)
D.Languages (LanguageID, Name)Elements (ElementID, Description, Text)

单项选择题Youneedtoprovideanalystreportingcapabilitiesthatfulfillthebusinessrequirements.Whatshouldyoudo?（）

A.Add a Report Viewer control to APP3.
B.Add an Internet Explorer ActiveX control to APP3. Set the controls URL to the A Datum Corporation Report Manager.
C.Create a hyperlink in APP3 that references the Report Manager.
D.Create a proxy class to the Report Server Web service.

单项选择题You are upgrading the database servers that are used by all of the companys applications. As the first step in the upgrade, you upgrade the development database servers. You need to verify that the upgrade of the database servers did not introduce any errors into the databases. What should you do?（）

A.Execute unit test scripts for each stored procedure in each database.
B.Execute the stored procedures in the SQL Server Management Studio debugger, and verify the results.
C.Set the database compatibility level on the database servers to 80.
D.Execute the application user interface test scripts to verify proper operation.

单项选择题Youneedtoprovideadhocreportingcapabilitiestofulfillbusinessrequirements.Whatshouldyoudo?（）

A.Create a SQL Server Reporting Services （SSRS） report. Enable customers to modify the report by using Report Builder.
B.Create an ASP.NET application that will enable customers to view and modify reports by calling the SQL Server Reporting Services （SSRS） API.
C.Create an ASP.NET application that will enable customers to view and modify reports by using a SQL Server Reporting Services （SSRS） ActiveX control.
D.Create a SQL Server Reporting Services （SSRS） Report Model. Enable customers to modify reports based on the model by using Report Builder.