默认题库 - MCITP(70-441)

单选题

You need to ensure that database schema changes in branch offices result in the proper notifications. What should you do?（）

A. Install Notification Services on all branch office servers， and configure Notification Services to use a local notifications database.
B. Specify that all SQL Server log files must be archived and sent by e-mail to the main office.
C. Implement DML triggers that use Database Mail to send an e-mail message about the DML activity.
D. Implement DDL triggers that use Database Mail to send an e-mail message about the DDL activity.

查看答案

多选题

You need to design the restrictions on the Bank.Customers table. Which three actions should you perform?（）

A. Design a trigger that verifies that the first names and surnames are not empty strings.
B. Design a check constraint that verifies that the first names and surnames are not empty strings.
C. Design a check constraint that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid.
Design a trigger that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid.
E. Design a check constraint that ensures that the phone number cannot be changed from a valid format to a null value or to an invalid format.
F. Design a trigger that ensures that the phone number cannot be changed from a valid format to a null value.

查看答案

单选题

You need to provide analyst reporting capabilities that fulfill the business requirements. What should you do?（）

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.
Create a hyperlink in APP3 that references the Report Manager.
D. Create a proxy class to the Report Server Web service.

查看答案

单选题

You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?（）

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.
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 the Cust_CalcData column is implemented appropriately. What should you do?（）

A. Specify that the Cust_CalcData column must be implemented as a computed column of the table.
B. Specify that the Cust_CalcData column must be indexed using a non-clustered index.
C. Specify that the Cust_CalcData column must be implemented as a column that uses a user-defined data type.
D. Specify that the Cust_CalcData column must be updated by a SQL Server Agent job that runs nightly.

查看答案

单选题

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 functio

查看答案

单选题

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.

查看答案

单选题

You need to provide ad hoc reporting capabilities to fulfill business requirements. What should you do?（）

A. Create a SQL Server Reporting Services （SSRS） report. Enable customers to modify the report by using Report Builder.
B. Create an ASNET application that will enable customers to view and modify reports by calling the SQL Server Reporting Services （SSRS） AP
Create an ASNET 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.

查看答案

多选题

You need to design the database permissions for access from the terminals to the database server. Which action or actions should you perform?（）

A. Create a database role named BankTerminals.
B. Grant the BankTerminals role the Execute permission for the WoodgroveBanking database.
C. Grant database access to the Windows Bank Terminals group， and add the group to the BankTerminals role.
D. Grant the BankTerminals role the Execute permission for the Bank schema.
E. Grant the Windows Bank Terminals group the Execute permission for the Bank schema.
F. Grant the BankTerminals role the Execute permission for all stored procedures and user-defined functions in the Bank schema.

查看答案