You are designing a SQL Server Integration Services(SSIS) solution. The solution will contain an SSISproject
that includes several SSIS packages. Each SSIS package will define the same connection managers and
variables. You have the following requirements:
• The deployment model must support changing the content of connection strings by using parameters at
execution time.
• The deployment model must automatically log events to the SSISOB database.
• Maximize performance at execution time.
You need to design a solution that meets the requirements. What should you do? (More than one answer
choice may achieve the goal. Select the BEST answer.)

You are designing a partitioning strategy for a large fact table in a data warehouse. Tens of millionsof new
records are loaded into the data warehouse weekly, outside of business hours. Most queries are generated by
reports and by cube processing. Data is frequently queried at the day level and occasionally at the month level.
You need to partition the table to maximize the performance of queries. What should you do? (More thanone
answer choice may achieve the goal. Select the BESTanswer.)

You are using SQL Server Data Tools to develop a SQL Server Integration Services (SSIS) project. The first
package that you create in this project contains a package connection that accesses a flat file. Additional
packages in the project must also access this file.You need to define and reuse the flat file connection in all
project packages. What should you do?

You are installing the Data Quality Client on user desktops. You need to ensure that the prerequisite software
components are installed. Which components must be present to meet this goal? (Each correct answer
presents part of the solution. Choose all that apply.)

You manage a SQL Server Master Data Services (MDS) environment. A new application requires access to the
product data that is available in the MDS repository. You need to design a solution that gives the application
access to the product data with the least amount ofdevelopment effort. What should you do?

You manage a SQL Server Master Data Services (MDS) environment. A new application requires access to the
product data that is available in the MDS repository. You need to design a solution that gives the application
access to the product data with the least amount ofdevelopment effort. What should you do?

You are creating a SQL Server Integration Services (SSIS) package that implements a Type 3 Slowly Changing
Dimension (SCD). You need to add a task or component to the package that allows you to implement the SCD
logic. What should you use?

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 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?

You are developing a project that contains multipleSQL 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 data files. 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?