HOTSPOT You are developing a data flow to load sales data into a fact table. In the data flow, you configure a Lookup Transformation in full cache mode to look up the product data for the sale. The lookup source…

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 a data warehouse developer responsible for developing data cleansing processes. Duplicate employees exist in an employee dimension. You need to map, discover, and manage domain values based on the employee dimension. Which Data Quality Services (DQS) option should…

HOTSPOT You administer a Microsoft SQL Server 2012 database. The database contains a table that has the following definition: You want to export data from the table to a flat file by using the SQL Server Import and Export Wizard.…

You administer a Windows Azure SQL Database database used for data warehouse operations. The database contains a table named OrdersHistory, defined as follows: A weekly ETL (extract-transform-load) runs a large INSERT statement to add data into the OrdersHistory table. The…

You are loading a dataset into SQL Server. The dataset contains numerous duplicates for the Artist and Song columns. The values in the Artist column in the dataset must exactly match the values in the Artist domain in the knowledge…

You are the administrator for a Data Quality Server. You are adding a user who must have permission to: • Edit and execute a project • View the activity monitoring data This user must not be able to: • Perform…

DRAG AND DROP You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse. You are developing the part of the SSIS package that populates the ProjectDates dimension table. The business key of the…

DRAG DROP You are developing a SQL Server Integration Services (SSIS) package that imports unsorted data into a data warehouse hosted on SQL Azure. You have the following requirements: • A destination table must contain all of the data in…

DRAG DROP You are creating a sales data warehouse. When a product exists in the product dimension, you update the product name. When a product does not exist, you insert a new record. In the current implementation, the DimProduct table…