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 are implementing the indexing strategy for a fact table in a data warehouse. The fact table is named
Quotes. The table has no indexes and consists of seven columns:
[ID]
[QuoteDate]
[Open]
[Close]
[High]
[Low]
[Volume]
Each of the following queries must be able to use acolumnstore index:
SELECT AVG ([Close]) AS [AverageClose]
FROM Quotes
WHERE [QuoteDate] BETWEEN ‘20100101’ AND ‘20101231’.
SELECT AVG([High] – [Low]) AS [AverageRange]
FROM Quotes
WHERE [QuoteDate] BETWEEN ‘20100101’ AND ‘20101231’.
SELECT SUM([Volume]) AS [SumVolume]
FROM Quotes
WHERE [QuoteDate] BETWEEN ‘20100101’ AND ‘20101231’
You need to ensure that the indexing strategy meetsthe requirements. The strategy must also minimize the
number and size of the indexes. What should you do?

You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse
hosted on SQL Azure. The package uses a Foreach container to process text files found in a folder. The
package must be deployed to a single server by using the Project Deployment model. Multiple SQL Server
Agent jobs call the package. Each job is executed on a different schedule. Each job passes a differentfolder
path to the package. You need to configure the package to accept the folder path from each job. Which
package configuration should you use?

You are creating a SQL Server Master Data Services (MDS) model. This model is used to store a master list of
products. An attribute must be added to the Productentity to define the sales manager responsible foreach
product. You need to create an attribute in the Product entity that prevents users from entering invalid sales
manager values. Which type of attribute should you create?

You are creating a SQL Server Master Data Services (MDS) model. This model is used to store a master list of
products. An attribute must be added to the Productentity to define the sales manager responsible foreach
product. You need to create an attribute in the Product entity that prevents users from entering invalid sales
manager values. Which type of attribute should you create?

You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse
hosted on SQL Azure. The package uses a Foreach container to process text files found in a folder. The
package must be deployed to a single server by using the Project Deployment model. Multiple SQL Server
Agent jobs call the package. Each job is executed on a different schedule. Each job passes a differentfolder
path to the package. You need to configure the package to accept the folder path from each job. Which
package configuration should you use?

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?

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 thetest
environment correctly. What should you do?

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?

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. Whatshould
you do?