HOTSPOT -You are developing a SQL Server Integration Service (SSIS) package. The package loads a customer dimension table by using a data flow task.Changes to the customer attributes must be tracked over time.You need to produce a checksum value to identify the rows that have changed since the last Extract, Transform and Load (ETL) process execution. You need to use the least amount of development effort to achieve this goal.Which transformation should you use? (To answer, select the appropriate transformation in the answer area.)Hot Area:
HOTSPOT -A SQL Server Integration Services (SSIS) package is designed to download data from a financial database hosted in SQL Azure.The connection string to the financial database is defined as a project parameter named FinConStr. The parameter value must be stored securely and must be set explicitly every time the package is executed.You need to configure the parameter to meet the requirements.What should you do? (To answer, configure the appropriate option or options in the dialog box in the answer area.)Hot Area:
HOTSPOT -You are the Master Data Services (MDS) administrator at your company.An existing user must be denied access to a certain hierarchy node for an existing model.You need to configure the user's permissions.Which user management menu item should you select? (To answer, configure the appropriate option or options in the dialog box in the answer area.)Hot Area:
DRAG DROP -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 base. The values in the Song column in the dataset can be a close match with the values in the Song domain.You need to use SQL Server Data Quality Services (DQS) to define a matching policy rule to identify duplicates.How should you configure the Rule Editor? (To answer, drag the appropriate answers to the answer area.)Select and Place:
HOTSPOT -You are developing a SQL Server Integration Services (SSIS) package. An Execute SQL task in the package checks product stock levels and sets a package variable named InStock to TRUE or FALSE depending on the stock level found.After the successful execution of the Execute SQL task, one of two data flow tasks must run, depending on the value of the InStock variable.You need to set the precedence constraints.Which value for the evaluation operation should you use? (To answer, select the appropriate option for the evaluation operation in the answer area.)Hot Area:
DRAG DROP -You are developing a SQL Server Integration Services (SSIS) package that downloads data from a Windows Azure SQL Database database.A stored procedure will be called in an Execute SQL task by using an ODBC connection. This stored procedure has only the @CustomerID parameter of type INT.A project parameter named CustID will be mapped to the stored procedure parameter @CustomerID.You need to ensure that the value of the CustID parameter is passed to the @CustomerID stored procedure parameter.In the Parameter Mapping tab of the Execute SQL task editor, how should you configure the parameter? (To answer, drag the appropriate option or options to the correct location or locations in the answer area.)Select and Place:
