70-463 Free Practice Test

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?

1. A. Source Assistant
2. B. Destination Assistant
3. C. Audit
4. D. Script Component

Correct Answer: D
Script Component Transformation:
The transformation that uses script to extract, transform, or load data. Note:
* SQL Server Integration Services provides three different types of data flow components: sources, transformations, and destinations. Sources extract data from data stores such as tables and views in relational databases, files, and Analysis Services databases. Transformations modify, summarize, and clean dat
A. Destinations load data into data stores or create in-memory datasets. Incorrect:
Not A, Not B: No Data Transforms called Source Assistant or Destination Assistant Not C: Not related to auditing

You are developing a SQL Server Integration Services (SSIS) project that copies a large amount of rows from a SQL Azure database. The project uses the Package Deployment Model. This project is deployed to SQL Server on a test server.
You need to ensure that the project is deployed to the SSIS catalog on the production server. What should you do?

1. A. Open a command prompt and run the dtexec /dumperror /conn command.
2. B. Create a reusable custom logging component and use it in the SSIS project.
3. C. Open a command prompt and run the gacutil command.
4. D. Add an OnError event handler to the SSIS project.
5. E. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.
6. F. Open a command prompt and run the dtexec /rep /conn command.
7. G. Open a command prompt and run the dtutil /copy command.
8. H. Use an msi file to deploy the package on the server.
9. I. Configure the SSIS solution to use the Project Deployment Model.
10. J. Configure the output of a component in the package data flow to use a data tap.
11. K. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.

Correct Answer: I
References:
http://msdn.microsoft.com/en-us/library/hh231102.aspx http://msdn.microsoft.com/en-us/library/hh213290.aspx http://msdn.microsoft.com/en-us/library/hh213373.aspx

DRAG DROP
A SQL Server Integration Services (SSIS) package named DataFeed interacts with an external vendor data feed. The package is executed several times a day, either as part of other packages' control flow or by itself. The external data feed is unreliable because network failures and slow response times are frequent. The package is currently deployed on the file system.
To analyze the reliability of the external data feed, you must collect execution data. Every time the DataFeed package is executed, the following information must be logged:
✑ Start Time
✑ End Time
✑ Execution Result
✑ Execution Duration
You need to design a logging solution that meets the requirements by using the least amount of administrative and development effort.
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.)

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

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

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?

1. A. Multicast
2. B. Conditional Split
3. C. Destination Assistant
4. D. Script Task

Correct 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.

You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base.
In the mapping configuration, two of the three columns are mapped to existing domains in the knowledge base. The third column, named Group, does not yet have a domain.
You need to complete the mapping of the Group column. What should you do?

1. A. Map a composite domain to the source column.
2. B. Create a composite domain that includes the Group column.
3. C. Add a domain for the Group column.
4. D. Add a column mapping for the Group column.

Correct Answer: C