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?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to deploy a new database to the SQL Server 2008 Analysis Services (SSAS) instance. The database contains a cube. The cube contains three Type 1 slowly changing dimensions. The database is updated throughout the day by adding 5,000 rows of data every hour. You need to ensure that the cube always contains up-to-date data. You also need to ensure that the users can access the cube during cube processing.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes a SQL Server 2008 Analysis Services (SSAS) application that resides on a single server.
Data in the SSAS database grows every month.
You need to provide a scalability strategy that meets the following requirements:
-Maximizes the end-user throughput.
-Minimizes daily downtime window due to processing.
-Accommodates an unexpected increase in the number of users.

What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You have deployed a SQL Server 2008 Reporting Services (SSRS) application. The number of users for the SSRS application increases. This results in performance problems. The datasets for the reports are optimized.
You investigate the SSRS deployment and discover the following characteristics:
-Users report that the reports take a long time to run.
-There are a large number of graphical reports that summarize data.
-Subscription processing affects the performance of reports that are run by interactive users.

You need to modify the SSRS infrastructure to resolve the performance problems.
Which scale-out strategy should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. The data warehouse contains a table named Employee Dimension.
The table contains the following three attributes:
-EmployeeID
-EmployeeName
-ReportsTo

The ReportsTo attribute tracks the EmployeeID attribute of the manager that an employee reports to.
You need to ensure that sales data of only managers and the names of all employees reporting to each of these managers are displayed. You want to achieve this goal by using a hierarchy model that provides the best possible performance when the data warehouse is queried.
Which hierarchy model should you use?