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?

HOTSPOT
You are editing a SQL Server Integration Services (SSIS) package. You need to edit the Script task that has an
expression defined. Which task should you select? To answer, select the appropriate setting or settings in the
answer area.

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package.
The package uses custom functionality that accessesa SQL Server database.
The custom functionality must be implemented by using Language Integrated Query (LINQ).
You need to ensure that the LINQ code can be debugged at design time.
What should you select from the SSIS Toolbox? (To answer, drag the appropriate item to the correct location in
the answer area.)

HOTSPOT
You are editing a SQL Server Integration Services (SSIS) project named Project1 in SQL Server Data Tools. A
package Connection Manager has been parameterized with project scope. You need to display the parameters
that have been generated for the Connection Manager. What should you use? To answer, select the
appropriate setting or settings in the answer area.

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 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 building a SQL Server Integration Services (SSIS) package to load data from all files that are
automatically copied to a directory each night through an external FTP process. You need to load data from all
copied files to a destination table in SQL Server. Which three steps 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.)

You administer a Microsoft SQL Server database. Service accounts for SQL Agent are configured to use a
local user. A Microsoft SQL Server Integration Services (SSIS) job step has been created within a SQL Server
Agent job. The SSIS package accesses a network share when exporting data from a SQL Server database.
When you execute the SQL Server Agent job, it failsdue to a permissions failure on a share on a remote
server. You need to ensure that the SQL Server Agent job can execute the SSIS package. Which four 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.)