You are using the Master Data Services (MDS) Add-in for Excel to configure the entities in a model. The model consists of two entities: one named Customer and one named State. You open the Customer entity. Currently, data stewards can…
Your company is evaluating the data cleansing capabilities of SQL Server Data Quality Services (DQS). A stand-alone server will be used to host DQS, as well as all related services necessary to run this service. You need to install the…
You are developing a SQL Server Integration Services (SSIS) package. You use a Data Profiling task to examine the data from a source system. You need to establish: • The minimum and maximum dates for the datetime columns in the…
You are developing a SQL Server Integration Services (SSIS) package. The data source for the data flow task is a table that has been configured as a change data capture (CDC) table. You are using a CDC Source component to…
You are developing a SQL Server Integration Services (SSIS) package. The package must run a parameterized query against a Windows Azure SQL Database database. You need to use the least amount of development effort to meet the package requirement. Which…
You are developing a SQL Server Integration Services (SSIS) package. The package contains an ADO object source variable that holds a result set that was returned by a stored procedure execution. You need to add and configure a container that…
You are maintaining a SQL Server Integration Services (SSIS) package. The package uses custom functionality that is implemented in Microsoft Visual C#. The implementation of the custom functionality changes overtime. The design of the package allows you to deploy new…
You are the data steward at your company. Duplicate customers exist in a Microsoft Excel workbook. You create a Data Quality Services (DQS) knowledge base and matching policy to identify these duplicate customers. You need to identify the duplicate customers.…
You are developing a SQL Server Integration Services (SSIS) package. The data source for the data flow task is a table that has been configured as a change data capture (CDC) table. You are using a CDC Source component to…
You are developing a SQL Server Integration Services (SSIS) package. The package contains several tasks that must repeat until an expression evaluates to FALSE. You need to add and configure a container to enable this design. Which three actions should…