web analytics

You need to complete the mapping of the Team Type column. What should you do?

You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base. In the mapping configuration, two of the three columns

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 users belonging to a specific Active Directory group access to the Data Quality Server. Which SQL Server

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

You need to produce the CSV file with the least amount of development effort. 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

You need to create a hierarchy representing the organizational structure of the company. Which hierarchy type should you use?

You are creating a SQL Server Master Data Services (MDS) model for a company. The source data for the company is stored in a single table that contains the manager-to-subordinate

You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services (DQS). You need to complete the post-installation configuration. What should you do?

You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services (DQS). You need to complete the post-installation configuration. What should you do? A.

You need to create an attribute in the Product entity that prevents users from entering invalid sales manager values. Which type of attribute should you create?

You are creating a SQL Server Master Data Services (MDS) model. This model is used to store a master list of products. An attribute must be added to the Product

Which two components must be present to meet this goal? Each correct answer presents part of the solution.

You are installing the Data Quality Client on user desktops. You need to ensure that the prerequisite software components are installed. Which two components must be present to meet this

In the Parameter Mapping tab of the Execute SQL task, StringVar has been added as the only parameter. You must configure the SQLStatement property of the Execute SQL task. Which SQL statement should you use?

You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse. You add an Execute SQL task to the control flow. The task must

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

You need to produce the CSV file with the least amount of development effort. 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

You need to meet the company’s policy requirements. Which event handler should you use?

You are designing a SQL Server Integration Services (SSIS) package that uploads a file to a table named Orders in a SQL Azure database. The company’s auditing policies have the

You need to meet the company's policy requirements. Which event handler should you use?

You are designing a SQL Server Integration Services (SSIS) package that uploads a file to a table named Orders in a SQL Azure database. The company’s auditing policies have the

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 that imports data into a data warehouse hosted on Microsoft Azure SQL database. The package uses a Foreach container to

You need to add the Environment to the project. Which stored procedure should you use?

You are using a SQL Server Integration Services (SSIS) project that is stored in the SSIS catalog. An Environment has been defined in the SSIS catalog. You need to add

You need to reuse the Fuzzy Lookup match index to increase performance and reduce maintenance. What should you do?

You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup transformation. The reference data to be used in the transformation does not change. You need

You need to define and reuse the flat file connection in all project packages. What should you do?

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

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

You need to select the appropriate data flow transformation to meet this requirement. Which two transformations can you use to achieve the goal? Each correct answer presents a complete solution.

You are creating a SQL Server Integration Services (SSIS) package to retrieve product data from two different sources. One source is hosted in a SQL Azure database. Each source contains

You need to execute the package without importing it to the SSIS server. What should you use to execute the package? (Each correct answer presents a complete solution. Choose all that apply.)

You develop and deploy a SQL Server Integration Services (SSIS) package. The package is stored in the file system. You need to execute the package without importing it to the

You need to ensure that the custom component is deployed on a test environment correctly. What should you do?

Note: This question is a part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question

You need to ensure that the project is deployed to the SSIS catalog on the production server. What should you do?

You are developing a SQL Server Integration Services (SSIS) project that copies a large amount of rows from a SQL Azure database. The project uses the Package Deployment Model. This

You need to configure a logging methodology that meets the requirements while minimizing the amount of deployment and development effort. What should you do?

To facilitate the troubleshooting of SQL Server Integration Services (SSIS) packages, a logging methodology is put in place. The methodology has the following requirements: The deployment process must be simplified.

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

You need to ensure that the indexing strategy meets the requirements. The strategy must also minimize the number and size of the indexes. What should you do?

You are implementing the indexing strategy for a fact table in a data warehouse. The fact table is named Quotes. The table has no indexes and consists of seven columns:

You need to redesign the dimension to enable the full historical reporting of changes to multiple customer attributes including Postcode. What should you do?

You are reviewing the design of a customer dimension table in an existing data warehouse hosted on SQL Azure. The current dimension design does not allow the retention of historical

You need to design a table structure to ensure that certain users can see sales data for only certain districts. Some users must be permitted to see sales data from multiple districts. What should you do?

You are designing a data warehouse hosted on SQL Azure. The data warehouse currently includes the dimUser and dimDistrict dimension tables and the factSales fact table. The dimUser table contains

You need to design the software title dimension. The solution should use as few tables as possible while supporting all the requirements. What should you do?

You are designing a data warehouse for a software distribution business that stores sales by software title. It stores sales targets by software category. Software titles are classified into subcategories

You need to design a solution that can join a single time dimension to both fact tables. What should you do?

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

You need to upgrade the package to SQL Server 2012. Which tool should you use?

You maintain a SQL Server Integration Services (SSIS) package. The package was developed by using SQL Server 2008 Business Intelligence Development Studio (BIDS). The package includes custom scripts that must

Where can you find this information?

A SQL Server Integration Services (SSIS) package on a computer is failing periodically in production. The package was created less than one year ago and was deployed to the SSIS

You need to create the SSIS catalog on the production server and ensure that the operations log cleaning requirement is met. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

You install a SQL Server database engine instance on a production server. A month later, you install SQL Server Integration Services (SSIS). You must develop an SSIS project and deploy

You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance. What should you do?

You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data warehouse every night. The SQL Azure data contains many misspellings and variations of

What should you do? Sensitive property of the parameters to True.

You are developing a project that contains multiple SQL Server Integration Services (SSIS) packages. The packages will be deployed to the SSIS catalog. One of the steps in each package