You are developing a SQL Server Integration Services (SSIS) package. You need to design a package to
change a variable value during package execution by using the least amount of development effort. What
should you use?

You are designing a data warehouse with two fact tables. The first table contains sales per month and the
second table contains orders per day. Referential integrity must be enforced declaratively. You need to design a
solution that can join a single time dimension to both fact tables. What should you do?

You are maintaining a Data Quality Services (DQS) environment. The production server failed and a new server
has been set up. The DQS databases are restored to a new server. All the appropriate permissions are
granted. DQS users are experiencing issues connecting to the new Data Quality Server. You need to enable
users to connect to the new server. Which Surface Area Configuration property should you enable

You are reviewing the design of a student dimension table 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?

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 maintain while ensuring that all dimensional data from the three
original solutions is represented. What should you do?

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 should you use?

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 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 development effort.
What should you do?

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