Microsoft 70-463 Exam Practice Test Instant Access

Question 1

You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a Microsoft Azure SQL Database database. The package has been deployed to a 64-bit production SQL Server.

The package fails when executed on the production server.

You need to ensure that the package can load the 32-bit Excel workbook data without errors.

What should you do?

AReplace the SSIS Excel source with a SQL Server source.

BEnable Address Windowing Extensions (AWE) for the local SQL Server instance.

CInstall a 32-bit instance of SSIS side-by-side with the 64-bit version.

DExecute the package by using the 32-bit run-time option.

Answer : D

If the computer has a 32-bit version of Office, then you have to install the 32-bit version of the components, and you also have to ensure that you run the package in 32-bit mode.

References:

https://docs.microsoft.com/en-us/sql/integration-services/connection-manager/connect-to-an-excel-workbook

Question 2

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

The package is stored as the myPackage.dtsx file in the root directory of the C drive of the SSIS server.

You need to run the package from the command prompt.

Which command should you use?

Adtexec /sql myPackage

Bdtexec /d 'C:\File System\myPackage.dtsx'

Cdtexec /f 'C:\myPackage.dtsx'

Ddtexec /com 'myPackage.dtsx'

Answer : C

Question 3

You are installing SQL Server Data Quality Services (DQS).

You need to give specific users access to the Data Quality Server.

Which SQL Server application should you use?

ASQL Server Configuration Manager

BSQL Server Data Tools

CSQL Server Management Studio

DData Quality Client

Answer : C

Ref: http://msdn.microsoft.com/en-us/library/hh213045.aspx

Question 4

You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on Windows Azure SQL Database. One of the columns in the data source is named ProductCode.

Some of the data to be loaded will reference products that need special processing logic in the data flow.

You need to enable separate processing streams for a subset of rows based on the source product code.

Which Data Flow transformation should you use?

AMulticast

BConditional Split

CDestination Assistant

DScript Task

Answer : B

We use Conditional Split to split the source data into separate processing streams.

A Script Component (Script Component is the answer to another version of this question) could be used but this is not the same as a Script Task.

Question 5

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?

ASet the Sensitive property of the parameters to True.

BSet the ProtectionLevel property of the package to EncryptSensitiveWithUserKey.

CChange the parameters to package parameters.

DChange the project to the Legacy Deployment model.

Answer : A

Question 6

You are designing a SQL Server Integration Services (SS1S) 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?

AOnProgress

BOnlnformation

COnPostExecute

DOnComplete

Answer : C

Question 7

Which of the following statements about simple and complex data movements are true? (Choose all that

apply.)

ASimple data movements only have a single data source and a single data destination.

BComplex data movements require data to be transformed before it can be stored at the destination.

CIn simple data movements, data transformations are limited to data type conversion.

DIn complex data movements, additional programmatic logic is required to merge source data with
destination data.

Answer : B, D

References:

http://colleenmorrow.com/2014/12/09/exam-prep-70-463-introduction-to-ssdt/

Microsoft 70-463 Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 Exam Practice Test