Ensurepass

QUESTION 71

You are adding a new capability to several dozen SQL Server Integration Services (SSIS) packages. The new capability is not available as an SSIS task. Each package must be extended with the same new capability. You need to add the new capability to all the packages without copying the code between packages. What should you do?

 

A.     Use the Expression task.

B.      Use the Script component.

C.      Use the Script task.

D.     Develop a custom task.

E.      Develop a custom component.

 

Correct Answer: D

 

 

QUESTION 72

You are deploying a new SQL Server Integration Services (SSIS) project to the test environment. A package in the project uses a custom task component. You need to ensure that the custom object is deployed on the test environment correctly. What should you do?

 

A.     Run the package by using the dtexec /rep /conn command.

B.      Create a reusable custom logging component.

C.      Create an OnError event handler.

D.     Use the gacutil command.

E.      Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to

store the configuration.

F.      Run the package by using the dtexec /dumperror /conn command.

G.     Use the Integration Services Deployment Wizard.

H.     Deploy the package by using an msi file.

I.       Add a data tap on the output of a component in the package data flow.

J.       Run the package by using the dtexecui.exe utility and the SQL Log provider.

K.      Use the dtutil /copy command.

 

Correct Answer: D

 

 

QUESTION 73

You are writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy system. Data integrity in the legacy system is very poor. Invalid rows are discarded by the package but must be logged to a CSV file for auditing purposes. You need to establish the best technique to log these invalid rows while minimizing the amount of development effort. What should you do?

 

A.     Add a data tap on the output of a component in the package data flow.

B.      Deploy the package by using an msi file.

C.      Run the package by using the dtexecui.exe utility and the SQL Log provider.

D.     Uses the dtutil /copy command.

E.      Create an OnError event handler.

F.      Use the Integration Services Deployment Wizard.

G.     Use the gacutil command.

H.     Create a reusable custom logging component.

I.       Run the package by using the dtexec /rep /conn command.

J.       Run the package by using the dtexec /dumperror /conn command.

K.      Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to

store the configuration.

 

Correct Answer: A

 

 

QUESTION 74

You are deploying a project to the SQL Server Integration Services (SSIS) catalog. You need to ensure that the project is deployed to the production environment with the least amount of administrative effort. What should you do?

 

A.     Create an On Error event handler.

B.      Add a data tap on the output of a component in the package data flow.

C.      Use the gacutil command.

D.     Create a reusable custom logging component.

E.      Run the package by using the dtexecui.exe utility and the SQL Log provider.

F.      Run the package by using the dtexec /rep /conn command.

G.     Use the Integration Services Deployment Wizard.

H.     Run the package by using the dtexec /dumperror /conn command.

I.       Use the dtutil /copy command.

J.       Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to

store the configuration.

K.      Deploy the package by using an msi file.

 

Correct Answer: G

 

 

QUESTION 75

Occasionally a job that executes an existing SQL Server Integration Services (SSIS) package does not complete and nothing is processed. You need to ensure that package logging occurs. Your solution must minimize deployment and development efforts. What should you do?

 

A.     Create a reusable custom logging component.

B.      Use the gacutil command.

C.      Use the Integration Services Deployment Wizard.

D.     Run the package by using the dtexec /rep /conn command.

E.      Add a data tap on the output of a component in the package data flow.

F.      Create an OnError event handler.

G.     Use the dtutil /copy command.

H.     Deploy the package by using an msi file.

I.       Run the package by using the dtexec /dumperror /conn command.

J.       Run the package by using the dtexecui.exe utility and the SQL Log provider.

K.      Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to

store the configuration.

 

Correct Answer: J

 

 

QUESTION 76

You are the data steward for a Business Intelligence project. You must identify duplicate rows stored in a SQL Server table and output discoveries to a CSV file. A Data Quality Services (DQS) knowledge base has been created to support this project. You need to produce the CSV file with the least amount of development effort. What should you do?

 

A.     Create an Integration Services package and use a Data Profiling transform.

B.      Create a custom .NET application based on the Knowledgebase class.

C.      Create a CLR stored procedure based on the Knowledgebase class.

D.     Create a Master Data Services (MDS) business rule.

E.      Create a data quality project.

Correct Answer: E

 

 

QUESTION 77

You are designing a data warehouse hosted on SQL Azure. The data warehouse currently includes the dimUser and dimDistrict dimension tables and the factSales fact table. The dimUser table contains records for each user permitted to run reports against the warehouse, and the dimDistrict table contains information about sales districts. The system is accessed by users from certain districts, as well as by area supervisors and users from the corporate headquarters. You need to design a table structure to ensure that certain users can see sales data for only certain districts. Some users must be permitted to see sales data from multiple districts. What should you do?

 

A.     Create a userDistrict table that contains primary key columns from the dimUser and

dimDistrict tables.

B.      Partition the factSales table on the district column.

C.      Add a district column to the dimUser table.

D.     For each district, create a view of the factSales table that includes a WHERE clause for the

district.

 

Correct Answer: A

 

 

QUESTION 78

You are developing a project that contains multiple SQL Server Integration Services (SSIS) packages. The packages will be deployed to the SSIS catalog. One of the steps in each package accesses an FTP site to download sales transaction data. You create project parameters to store the username and password that are used to access the FTP site. You need to ensure that the username and password values are encrypted when they are deployed. What should you do?

 

A.     Set the Sensitive property of the parameters to True.

B.      Set the ProtectionLevel property of the package to EncryptSensitiveWithUserKey.

C.      Change the parameters to package parameters.

D.     Change the project to the Legacy Deployment model.

 

Correct Answer: A

 

 

QUESTION 79

You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasks and no other tasks. The package and all three Execute SQL tasks have their TransactionOption property set to Supported. You need to ensure that if any of the Execute SQL tasks fail, all three tasks will roll back their changes. What should you do?

 

A.     Change the TransactionOption property of the package to Required.

B.      Change the TransactionOption property of all three Execute SQL tasks to Required.

C.      Move the three Execute SQL tasks into a Sequence container.

D.     Move the three Execute SQL tasks into a Foreach Loop container.

 

Correct Answer: A

 

 

QUESTION 80

You are designing a SQL Server Integration Services (SSIS) package that uploads a file to a table named Orders in a SQL Azure database. The company’s auditing policies have the following requirements:

 

Ÿ   An entry must be written to a dedicated SQL Server log table named OrderLog.

Ÿ   The entry must be written as soon as the file upload task completes.

 

You need to meet the company’s policy requirements. Which event handler should you use?

 

A.     OnWarning

B.      OnVariableValueChanged

C.      OnExecStatusChanged

D.     OnPostExecute

 

Correct Answer: D

 

Free VCE & PDF File for Microsoft 70-463 Real Exam

Instant Access to Free VCE Files: MCSE|MCSA|MCITP…
Instant Access to Free PDF Files: MCSE|MCSA|MCITP…