Youneedtoprovideanalystreportingcapabilitiesthatfulfill……

单项选择题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.

单项选择题Youneedtocleanseandstandardizethedataonpotentialsurveyparticipantspriortoinsertingitintothestagingdatabase.Whatshouldyoudo?（）

A.Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.
B.Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.
C.Create a SQL Server Integration Services （SSIS） package to import， standardize， and cleanse the data.
D.Create a CLR stored procedure to import the data into a staging table， to cleanse and standardize the data， and to insert the data into the database.

多项选择题You need to ensure that survey customers are automatically notified when their survey results are available. You must also ensure that customers can manage their own recipient lists. Which two actions should you perform?（）

A.Create a Subscription Management interface that will allow customers to modify their recipient lists.
B.Create a custom Notification Services Content Formatter to send an e-mail message to customers when their survey results are available.
C.Create a custom Notification Services Event Provider to send an e-mail message to customers when their survey results are available.
D.Create a Notification Services custom delivery protocol to send an e-mail message to customers when their survey results are available.
E.Create Notification Services Event rules to send an e-mail message to customers when their survey results are available.

多项选择题YouaredesigningaperformancemonitoringplanforthedatabasethatsupportsAPP1.Youneedtomonitoronlynecessaryindicators.Whichindicatororindicatorsshouldyouincludein thebaseline?（）

A.response times for frequently used queries
B.database backup and restore completion times
C.disk I/O
D.CPU utilization
E.network packet size
F.SOAP requests failed