What should you use to execute the package?
You develop and deploy a SQL Server Integration Services (SSIS) package.
The package is stored in the file system.
You need to execute the package without importing it to the SSIS server.
What should you use to execute the package? (Each correct answer presents a complete
solution. Choose all that apply.)
Which three actions should you perform in sequence?
DRAG DROP
A SQL Server Integration Services (SSIS) project has been deployed to the SSIS catalog.
The project includes a project Connection Manager to connect to the data warehouse.
The SSIS catalog includes two Environments:
Development
QA
Each Environment defines a single Environment Variable named ConnectionString of type
string. The value of each variable consists of the connection string to the development or QA
data warehouses.
You need to be able to execute deployed packages by using either of the defined
Environments.
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.)
What should you configure?
You administer a Microsoft SQL Server 2012 server.
When transaction logs grow, SQL Server must send an email message to the database
administrators.
You need to configure SQL Server to send the email messages.
What should you configure?
You need to ensure that the Merge Join transformation works correctly without additional transformations
You are developing a data flow transformation to merge two data sources. One source
contains product data and the other source contains data about the country in which the
product was manufactured. Both data sources contain a two-character CountryCode column
and both use SQL Server. Both data sources contain an ORDER BY clause to sort the data
by the CountryCode column in ascending order.
You use a Merge Join transformation to join the data.
You need to ensure that the Merge Join transformation works correctly without additional
transformations.
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)
Which transformation should you use?
DRAG DROP
You use SQL Server Integration Services (SSIS) for extract, transformation, load (ETL)
processing.
Issues concerning addresses are discovered in the data warehouse that you manage.
Validation must separate the addresses into three categories:
Valid addresses
Autocorrected addresses
Invalid addresses
You need to enhance the SSIS packages to perform address validation by using an external
service.
Which transformation should you use? (To answer, drag the appropriate transformation from
the list of options to the correct location or locations in the answer area.)
You need to ensure that the application can connect to the named instance
You administer two instances of Microsoft SQL Server 2012. You deploy an application that
uses a database on the named instance.
The application is unable to connect to the database on the named instance.
You need to ensure that the application can connect to the named instance.
What should you do?
Which transformation types should you use?
You are creating a SQL Server Integration Services (SSIS) package to retrieve product data
from two different sources. One source is hosted in a SQL Azure database. Each source
contains products for different distributors.
Products for each distributor source must be combined for insertion into a single product
table destination.
You need to select the appropriate data flow transformation to meet this requirement.
Which transformation types should you use? (Each correct answer presents a complete
solution. Choose all that apply.)
You need to ensure that the following requirements are met: • The first row of the file contains the first r
HOTSPOT
You administer a Microsoft SQL Server 2012 database.
The database contains a table that has the following definition:
You want to export data from the table to a flat file by using the SQL Server Import and
Export Wizard.
You need to ensure that the following requirements are met:
• The first row of the file contains the first row of dat• a.
• Each record is of the same length.
• The date follows the U.S. date format.
• The file supports international characters.
What should you do? (To answer, configure the appropriate option or options in the dialog box in the answer area.)
Which four Transact-SQL statements should you use?
DRAG DROP
You administer a Microsoft SQL Server 2012 database.
You use an OrderDetail table that has the following definition:
You need to create a non-clustered index on the SalesOrderID column in the OrderDetail
table to include only rows that contain a value in the SpecialOfferID column.
Which four Transact-SQL statements should you use? (To answer, move the appropriate
statements from the list of statements to the answer area and arrange them in the correct order.)
Which page of the Lookup Transformation Editor should you select to configure the query?
HOTSPOT
You are developing a data flow to load sales data into a fact table. In the data flow, you
configure a Lookup Transformation in full cache mode to look up the product data for the sale.
The lookup source for the product data is contained in two tables.
You need to set the data source for the lookup to be a query that combines the two tables.
Which page of the Lookup Transformation Editor should you select to configure the query?
To answer, select the appropriate page in the answer area.