You are the Master Data Services (MDS) administrator at your company. An existing user needs to integrate data from other systems into MDS. You need to give the user permissions to integrate data. Which user management menu item should you…

You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server 2012 database. The package is allowed to connect to only one database. An Environment variable contains the name of the database. The OLE…

You are building a fact table in a data warehouse. The table must have a columnstore index. The table cannot be partitioned. You need to design the fact table and load it with data. Which three actions should you perform…

You are developing a SQL Server Integration Services (SSIS) package. The package control flow will contain many tasks. The tasks will execute consecutively and none will execute more than once. Certain groups of tasks will share variable and transaction scope.…

You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server 2012 database. The name of the target instance is passed to the package via an Environment variable. The Environment variable provides the server…

You administer a large and complex SQL Server Integration Services (SSIS) solution in the SSIS catalog. You are instructed to execute a package by using PowerShell. You need to create the correct PowerShell command. How should you place the four…

You are developing a SQL Server Integration Services (SSIS) package. OnError and OnWarning events must be logged for viewing in the built-in SSIS reports by using SQL Server Management Studio. You need to execute the package and minimize the number…

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…

You are developing a SQL Server Integration Services (SSIS) package. The package contains a user-defined variable named @Queue which has an initial value of 10. The package control flow contains many tasks that must repeat execution until the @Queue variable…

You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads rows from a source system and compares them to rows in a destination system. New rows will be inserted and…