You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design a logging strategy for all SQL Server 2008 Integration Services (SSIS) packages for your company. You want to log errors that occur in all existing and future packages to a SQL Server 2008 table.
You need to design the strategy to meet the following requirements:
-The logging mechanism must be reused by each package.
-Changes to the logging mechanism must be applied to all packages by using the minimum amount of administrative effort.

What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You develop 10 SQL Server 2008 Integration Services (SSIS) packages. You plan to include package configuration for all the packages.
The package configuration has the following requirements:
-All configurations are stored in a single location.
-Configuration variables are easily backed up and restored.
-Indirect configuration is used.
-The database administrators will use SQL Server client tools to change the configuration values.

You need to create package configurations for the packages to meet the configuration requirements.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You have created an extract, transform, and load (ETL) solution by using SQL Server 2008 Integration Services (SSIS). The solution contains 10 child packages and a parent package that executes the child packages in sequence.
You plan to deploy the solution to 20 locations that are not connected to each other. You need to deploy the solution by configuring the connection managers of all packages with the appropriate settings. You need to achieve this goal by using the minimum amount of administrative effort.
What should you do?

You are managing a Business Intelligence (BI) infrastructure that uses SQL Server 2008 Integration Services (SSIS). Your infrastructure has many SSIS solutions that contain several packages. The current backup strategy includes nightly backups of all databases on the server. You need to develop a deployment strategy that meets the following requirements:
-Deploys only the packages that have been modified.
-Includes all packages in the current backup strategy.

What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You develop a SQL Server 2008 Integration Services (SSIS) package to perform an extract, transform, and load (ETL) process from a Microsoft Access database to a SQL Server 2008 data warehouse. The package is developed on a computer that runs a 32-bit operating system. You deploy the package to a server that runs a 64-bit operating system. You create a SQL Server Agent job to run the package. The package fails to run when the job starts. You need to ensure that the package runs successfully.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to transform vehicle survey data from a flat file to a data warehouse. You need to design a solution that performs the following tasks:
-Redirect data of vehicle owners to a table named DimOwner.
-Redirect data of vehicle enthusiasts to a table named DimEnthusiast.
-Log each record’s key along with the data transfer date to an audit table.

What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You design a solution that analyzes the usage of discount vouchers issued by the company. The data warehouse of the company contains a dimension table named Vouchers. The dimension table contains two columns named VoucherNumber and CustomerFullName. A value for the CustomerFullName column is not available till the voucher is used. You need to configure the Slowly Changing Dimension transformation to load the Vouchers dimension even if there is a NULL value in the CustomerFullName column.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You have a SQL Server 2008 Integration Services (SSIS) package that runs against a SQL Server 2008 data source. The package contains an opening Execute SQL task that runs the BEGIN TRANSACTION command. This is followed by a Sequence task that contains additional Execute SQL tasks, each with the FailParentOnFailure property set to TRUE .
There are two Execute SQL tasks. The first task is connected to a Success precedence constraint that runs the COMMIT TRANSACTION command. The next task is connected to a Failure precedence constraint that runs the ROLLBACK TRANSACTION command. The package fails but the transaction is not rolled back. You need to ensure that the transaction is successfully rolled back if the package fails.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to transform sales data from a retail sales outlet database to a SQL Server 2008 data warehouse by using SQL Server 2008 Integration Services (SSIS). The retail sales database is an online transaction processing (OLTP) database that processes large amounts of transactions twenty-four hours a day.
You need to design the structure of the SSIS packages such that the performance of the source system is minimally affected.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You are building an extract, transform, and load (ETL) process by using SQL Server 2008 Integration Services (SSIS).
You stage data in a SQL Server 2008 database. You load a data warehouse that has 15 dimension tables and 3 fact tables.
You need to design a control flow that meets the following requirements:
-Each table must be loaded with its own SSIS package. All packages must be controlled from a master package.
-Dimension tables must have no interdependencies.
-Dimension tables must load without error before the Fact tables are loaded.
-Master package parallelism must be maximized.

What should you do?