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?

You design a Business Intelligence (BI) solution by using SQL Server 2008. The instance contains an SQL Server 2008 Analysis Services (SSAS) database. The SSAS database contains a cube named Sales. The Sales cube has a dimension named Geography and a role named roleEurope.
The Geography dimension has a hierarchy that contains the following members:
-Continent
-Region
-City

You plan to design the security configuration for the Sales cube. You need to enable the Read permissions for the roleEurope role. You also need to ensure that the roleEurope role can access only the Fact rows that are members of the Europe continent. Which Multidimensional Expressions (MDX) statement should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes a data warehouse that has an online transaction processing (OLTP) database as the data source.
The tables in the OLTP database do not include date or time information. On each execution, the SQL Server 2008 Integration Services (SSIS) package that copies the data must reload and process the entire dataset.
You plan to improve the process of loading the data warehouse. You need to ensure that the following requirements are met:
-Only new and modified data is processed.
-All modifications of the rows caused due to insert, update, and delete activities are processed.
-The impact of the loading process on the source system is minimal.

Which action should you perform on the tables that are involved in the load process?

You are the lead developer for a SQL Server 2008 data warehousing project. The source database for the project is an online transaction processing (OLTP) system. The OLTP system executes 4,000 transactions every minute during business hours. The OLTP system records only the date and time of insertion of a new row and not for the updates of existing rows.
You plan to design an extract, transform, and load (ETL) process for the project that populates a data warehouse from the source database.
The ETL process must be configured in the following manner:
-To run after business hours
-To capture new rows and existing rows that have been modified

You need to ensure that only new rows or modified rows from the database tables are processed by the ETL process.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. Several developers work on a large SQL Server 2008 Analysis Services (SSAS) project. Developers will work in parallel on the same cubes in the solution.
You need to manage the cube definitions to ensure that each developer’s work is not overwritten. You also need to ensure that conflicts can be easily resolved.
What should you recommend the developers to do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You develop a SQL Server 2008 Analysis Services (SSAS) project and use Microsoft Visual Source Safe (VSS) as the source control system. After making changes to the project, you check in the files to the VSS. Then, you deploy the project to a shared server for testing. Four new developers are assigned to work in parallel on the project. You need to ensure that the new developers can modify the most recent version of the project and test it without affecting the work of the existing developers.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution has a cube that is processed periodically. The cube takes several hours to process. Cube processing results in a considerable amount of downtime. You need to minimize the downtime while maintaining the best possible query performance of the cube.
What should you do?