HOTSPOT -You are designing a SQL Server Integration Services (SSIS) package configuration strategy.The package configuration must meet the following requirements:✑ Include multiple properties in a configuration.✑ Force packages to load all settings in the configuration.✑ Support Encrypting File System (EFS) formats.You need to select the appropriate configuration.Which configuration type should you use?To answer, select the appropriate option from the drop-down list in the dialog box.Hot Area:
You are designing a SQL Server Integration Services (SSIS) solution that will load multiple Online Transactional Processing (OLTP) data sources into a SQLServer data mart.You have the following requirements:✑ Ensure that the process supports the creation of an exception report that details possible duplicate key values, null ratios within columns, and column-length distributions of values.✑ Ensure that users can generate the exception report in an XML format.✑ Use the minimum development effort.You need to design the SSIS solution to meet the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables.You have the following requirements:✑ The deployment model must support changing the content of connection strings by using parameters at execution time.✑ The deployment model must automatically log events to the SSISDB database.✑ Maximize performance at execution time.You need to design a solution that meets the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
DRAG DROP -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 dataThis user must not be able to:✑ Perform any kind of knowledge management✑ Create or change a knowledge base✑ Terminate an activity or perform administrative dutiesYou need to develop a Transact-SQL (T-SQL) script to meet these requirements.What should you do? (To answer, drag the appropriate code segment or segments to the correct location or locations in the answer area.)Select and Place:
DRAG DROP -A new dedicated server is used to execute resource-intensive SQL Server Integration Services (SSIS) 2012 packages. The environment that you are deploying the packages to has the following constraints:✑ The operating system is Windows Server 2008 R2.✑ The SSIS packages are stored in the SSIS catalog.✑ Some of these SSIS packages use 32-bit custom components.You need to install only the components that are required to deploy and run the packages on the new server.Which three actions should you perform in sequence? (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 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?
