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?

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 of development effort. 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 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 designing a partitioning strategy for a large fact table in a data warehouse. Tens of millions of 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 than one
answer choice may achieve the goal. Select the BEST answer.)

You are designing a SQL Server Integration Services (SSIS) solution that will load multiple Online Transactional
Processing (OLTP) data sources into a SQL Server data mart. You have the following requirements:
• Ensure that the process supports the creation of an exception report that details possible duplicate key values,
null ratios within columns, and column-length distributions of values.
• Ensure that users can generate the exception report in an XML format.
• Use the minimum development effort.
You need to design the SSIS solution to meet the requirements. What should you do? (More than one answer
choice may achieve the goal. Select the BEST answer.)

You are designing a fact table in a SQL Server database. The fact table must meet the following requirements:
• Include a columnstore index.
• Allow users to choose up to 10 dimension tables and up to five facts at one time.
• Maximize performance of queries that aggregate measures by using any of the 10 dimensions.
• Support billions of rows.
• Use the most efficient design strategy.
You need to design the fact table to meet the requirements. What should you do? (More than one answer
choice may achieve the goal. Select the BEST answer.)