Microsoft-Implementing a Data Warehouse with Microsoft SQL Server 2012 Set 4

You have a server named SQL1 that has SQL Server Integration Services (SSIS) installed. SQL1 has eight CPUs, 8 GB of RAM, RAID-10 storage, and a 10-gigabit Ethernet connection. A package named Package1 runs on SQL1. Package1 contains 10 data tasks. Package1 queries 3 GB of data from the source system. You review the performance statistics on SQL1 and discover that Package1 executes slower than expected. You need to identify the problem that is causing Package1 to execute slowly. Which performance monitor counter data should you review?

Your company uses a proprietary encryption algorithm to secure sensitive data. A custom cryptographic assembly was developed in Microsoft .NET and is used in several applications. A SQL Server Integration Services (SSIS) package is importing data into a Microsoft Azure SQL Database. Some of the data must be encrypted with the proprietary encryption algorithm. You need to design the implementation strategy to meet the requirements while minimizing development and deployment effort and maximizing data flow performance. What should you do?

You have a database named Sales and a data warehouse named DataW. From Sales, you plan to bulk insert to a table in DataW that is more than 2 TB. The process will insert a minimum of 11 million rows simultaneously. You need to identify which data storage strategy must be used to minimize load times. Which data storage strategy should you identify?

You have a data warehouse that contains all of the sales data for your company. The data warehouse contains several SQL Server Integration Services (SSIS) packages. You need to create a custom report that contains the total number of rows processed in the package and the time required for each package to execute. Which view should you include in the report?

You are performance tuning a SQL Server Integration Services (SSIS) package to load sales data from a source system into a data warehouse that is hosted on a Microsoft Azure SQL Database. The package contains a data flow task that has seven source-to-destination execution trees. Only three of the source-to-destination execution trees are running in parallel. You need to ensure that all the execution trees run in parallel. What should you do?

You have a data warehouse that contains all of the sales data for your company. You need to design a SQL Server Integration Services (SSIS) package that reports the average value for one of the columns in a data flow. What should you add to the package?

You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model. A package in the project extracts data from a Microsoft Azure SQL Database. The package is deployed to SQL Server. The package is not producing the desired results. You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues. What should you do?

You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a Microsoft Azure SQL Database database. The package has been deployed to a 64-bit production SQL Server. The package fails when executed on the production server. You need to ensure that the package can load the 32-bit Excel workbook data without errors. What should you do?

You are developing a SQL Server Integration Services (SSIS) project to read and write data from a Windows Azure SQL Database database to a server that runs SQL Server 2012. The connection will be used by data flow tasks in multiple SSIS packages. The address of the target Windows Azure SQL Database database will be provided by a project parameter. You need to create a solution to meet the requirements by using the least amount of administrative effort and maximizing data flow performance. What should you do?

You need to extract data from delimited text files. What connection manager type would you choose?