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?

You are the data steward for a Business Intelligence project. You must identify duplicate rows stored in a SQL
Server table and output discoveries to a CSV file. A Data Quality Services (DQS) knowledge base has been
created to support this project. You need to produce the CSV file with the least amount of developmenteffort.
What should you do?

You are installing SQL Server Data Quality Services(DQS). You need to give users belonging to a specific
Active Directory group access to the Data Quality Server. Which SQL Server application should you use?

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

You are designing an enterprise star schema that will consolidate data from three independent data marts. One
of the data marts is hosted on SQL Azure. Most of the dimensions have the same structure and content.
However, the geography dimension is slightly different in each data mart. You need to design a consolidated
dimensional structure that will be easy to maintainwhile ensuring that all dimensional data from the three
original solutions is represented. What should you do?

You are reviewing the design of a student dimensiontable in an existing data warehouse hosted on SQL Azure.
The current dimension design does not allow the retention of historical changes to student attributes such as
ParentOccupation. You need to redesign the dimension to enable the full historical reporting of changes to
multiple student attributes including ParentOccupation. What should you do?