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 have a SQL Server Integration Services (SSIS) package named Package1.You discover that the Data Flow task for Package1 runs slower than expected.You need to reduce the amount of time required to run the Data Flow task.Which two actions should you perform? Each correct answer presents part of the solution.
DRAG DROP -You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment model.The project contains many packages. It is deployed on a server named SQLTest1. The project will be deployed to several servers that run SQL Server.The project accepts one required parameter. The data type of the parameter is a string.A SQL Agent job is created that will call the Loading.dtsx package in the project. A job step is created for the SSIS package.The job must pass the value of an SSIS Environment Variable to the project parameter. The value of the Environment Variable must be configured differently on each server that runs SQL Server. The value of the Environment Variable must provide the server name to the project parameter.You need to configure SSIS on the SQLTest1 server to pass the Environment Variable to the package.Which four actions should you perform in sequence by using SQL Server Management Studio?(To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)Select and Place:
You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasks and no other tasks. The three Execute SQL tasks modify products in staging tables in preparation for a data warehouse load.The package and all three Execute SQL product tasks have their TransactionOption property set to Supported.You need to ensure that if any of the three Execute SQL product tasks fail, all three tasks will roll back their changes.What should you do?
You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server table on ServerA. The package includes a data flow and is executed on ServerB. The destination table has its own identity column.The destination data load has the following requirements:✑ The identity values from the source table must be used.✑ Default constraints on the destination table must be ignored.✑ Batch size must be 100,000 rows.You need to add a destination and configure it to meet the requirements.Which destination should you use?
You maintain a SQL Server Integration Services (SSIS) package. The package was developed by using SQL Server 2008 Business Intelligence DevelopmentStudio (BIDS).The package includes custom scripts that must be upgraded.You need to upgrade the package to SQL Server 2012.Which tool should you use?
