Latest Real 70-463 Tests Dumps and VCE Exam Questions 141-150 | Microsoft MCSE Exams Practice Questions and Answers

Ensurepass

QUESTION 141

DRAG DROP

You are developing a SQL Server Integration Services (SSIS) package that downloads data from a

Windows Azure SQL Database. A stored procedure will be called in an Execute SQL task by using

an ODBC connection. This stored procedure has only the @CustomerID parameter of type INT. A

project parameter named CustID will be mapped to the stored procedure parameter

@CustomerID. You need to ensure that the value of the CustID parameter is passed to the

@CustomerID stored procedure parameter. In the Parameter Mapping tab of the Execute SQL

task editor, how should you configure the parameter?

To answer, drag the appropriate option or options to the correct location or locations in

the answer area.

Select and Place:

Correct Answer:

QUESTION 142

DRAG DROP

You are developing a SQL Server Integration Services (SSIS) package that loads data into a data

warehouse hosted on Windows Azure SQL Database. You must combine two data sources

together by using the ProductID column to provide complete details for each record. The data

retrieved from each data source is sorted in ascending order by the ProductID column. You need

to develop a data flow that imports the data while meeting the requirements. How should you

develop the data flow?

To answer, drag the appropriate transformation from the list of transformations to the correct

location in the answer area.

Select and Place:

Correct Answer:

QUESTION 143

DRAG DROP

You are developing a SQL Server Integration Services (SSIS) package. The package contains several

tasks that must repeat until an expression evaluates to FALSE. You need to add and configure a

container to enable this design. Which three actions should you perform in sequence?

To answer, move the appropriate actions from the list of actions to the answer area and arrange

them in the correct order.

Select and Place:

Correct Answer:

QUESTION 144

You are designing a data warehouse with two fact tables. The first table contains sales per month

and the second table contains orders per day. Referential integrity must be enforced declaratively. You need to design a solution that can join a single time dimension to both fact tables. What should you do?

A. Create a view on the sales table.

B. Partition the fact tables by day.

C. Create a surrogate key for the time dimension.

D. Change the level of granularity in both fact tables to be the same.

Correct Answer: D

QUESTION 145

You are deploying a new SQL Server Integration Services (SSIS) package to several servers.

The package must meet the following requirements:

.NET Common Language Runtime (CLR) integration in SQL Server must not be enabled.

The Connection Managers used in the package must be configurable without editing the

package.

The deployment procedure must be automated as much as possible.

You need to set up a deployment strategy that meets the requirements. What should you do?

A. Use the gacutil command.

B. Use the dtutil /copy command.

C. Use the Project Deployment Wizard.

D. Create an OnError event handler.

E. Create a reusable custom logging component.

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

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

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

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

J. Deploy the package by using an msi file.

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

store the configuration.

Correct Answer: B

QUESTION 146

You administer a SQL Server Integration Services (SSIS) solution in the SSIS catalog. A SQL Server

Agent job is used to execute a package daily with the basic logging level. Recently, the package

execution failed because of a primary key violation when the package inserted data into the

destination table. You need to identify all previous times that the package execution failed

because of a primary key violation. What should you do?

A. Use an event handler for OnError for the package.

B. Use an event handler for OnError for each data flow task.

C. Use an event handler for OnTaskFailed for the package.

D. View the job history for the SQL Server Agent job.

E. View the All Messages subsection of the All Executions report for the package.

F. Store the System::SourceID variable in the custom log table.

G. Store the System::ServerExecutionID variable in the custom log table.

H. Store the System::ExecutionInstanceGUID variable in the custom log table.

I. Enable the SSIS log provider for SQL Server for OnError in the package control flow.

J. Enable the SSIS log provider for SQL Server for OnTaskFailed in the package control flow.

K. Deploy the project by using dtutil.exe with the /COPY DTS option.

L. Deploy the project by using dtutil.exe with the /COPY SQL option.

M. Deploy the .ispac file by using the Integration Services Deployment Wizard.

N. Create a SQL Server Agent job to execute the SSISDB.catalog.validate_project stored

procedure.

O. Create a SQL Server Agent job to execute the SSISDB.catalog.validate_package stored

procedure.

P. Create a SQL Server Agent job to execute the SSISDB.catalog.create_execution and

SSISDB.catalog.start_execution stored procedures.

Q. Create a table to store error information. Create an error output on each data flow

destination that writes OnError event text to the table.

R. Create a table to store error information. Create an error output on each data flow

destination that writes OnTaskFailed event text to the table.

Correct Answer: E

QUESTION 147

You are developing a SQL Server Integration Services (SSIS) package to load data into a Windows

Azure SQL Database database. The package consists of several data flow tasks. The package has

the following auditing requirements:

If a data flow task fails, a Transact-SQL (T-SQL) script must be executed.

The T-SQL script must be executed only once per data flow task that fails, regardless of the

nature of the error.

You need to ensure that auditing is configured to meet these requirements. What should you do?