DRAG DROP -You are editing a SQL Server Integration Services (SSIS) package that contains a task with a sensitive property.You need to create a project parameter and configure it so that its value is encrypted when it is deployed to the SSIS catalog.Which three steps 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 are reviewing the design of an existing fact table named factSales, which is loaded incrementally from a SQL Azure database by a SQL Server IntegrationServices (SSIS) package each hour. The fact table has approximately 4 billion rows and is dimensioned by product, sales date, and sales time of day.The database administrator is concerned about the rapid growth of the database and users experience poor reporting performance against this database.Reporting requirements have recently changed and the only remaining report that uses this fact table reports sales by product name, sale month, and sale year.No other reports will be created against this table.You need to reduce the report processing time and minimize the growth of the database.What should you do?
You are developing a SQL Server Integration Services (SSIS) package to load data into a data warehouse. The package consists of several data flow tasks.The package experiences intermittent errors in the data flow tasks.If any data flow task fails, all package error information must be captured and written to a SQL Server table by using an OLE DB connection manager.You need to ensure that the package error information is captured and written to the table.What should you do?
You are adding a new capability to several dozen SQL Server Integration Services (SSIS) packages.The new capability is not available as an SSIS task. Each package must be extended with the same new capability.You need to add the new capability to all the packages without copying the code between packages.What should you do?
DRAG DROP -A new SQL Server Integration Services (SSIS) project is deployed to the SSIS catalog.To troubleshoot some data issues, you must output the data streaming through several data flows into text files for further analysis. You have the list of data flow package paths and identification strings of the various task components that must be analyzed.You need to create these output files with the least amount of administrative and development effort.Which three stored procedures should you execute 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 develop a SQL Server Integration Services (SSIS) package in a project by using the Project Deployment Model. It is regularly executed within a multi-stepSQL Server Agent job.You make changes to the package that should improve performance.You need to establish if there is a trend in the durations of the next 10 successful executions of the package. You need to use the least amount of administrative effort to achieve this goal.What should you do?
