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?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design a dimensional modeling strategy for a new data warehouse application.
The application contains the following dimensions:
-Product
-Time
-Customer
-SalesPerson

The application contains the following cubes:
-Sales that contains all the dimensions
-Products that contain the Product and the Time dimensions Customers that contain the Customer and the Time dimensions

You need to design an appropriate dimensional modeling strategy for the Product and the Time dimensions.
Which dimensional model should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. At the end of every business day, an application records the inventory to the Products table. The business solution for the application must accommodate the following features:
-The content of the Products table varies every day.
-Historical product attributes are not stored.

You need to identify an appropriate dimensional model to meet the business solution.
Which model should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design a dimensional modeling strategy for a new data warehouse. The data warehouse has a dimension table named Employees. The Employees dimension table contains information about the employees and their departments.
Employees are moved to different departments frequently. You need to preserve the historical information of the Employees table.
Which dimensional model should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You have a SQL Server 2008 Analysis Services (SSAS) cube. Some users only use Microsoft Excel 2007.
Some users only use Microsoft ProClarity.
You plan to add new key performance indicators (KPIs). You need to ensure that the KPIs meet the following requirements:
-Provide all users access to the new KPIs.
-Minimize future maintenance.

What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design a report that uses data obtained from a SQL Server 2008 Analysis Services (SSAS) instance.
The SSAS cube contains five parentchild key performance indicators (KPIs). Each KPI has nine children.
You need to create an executive dashboard in Microsoft Office SharePoint Server (MOSS) that displays the KPIs and depicts the parentchild relationship.
Which technology should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to develop a report that will use data obtained from a SQL Server 2008 Analysis Services (SSAS) instance. The solution has many key performance indicators (KPIs). You need to ensure that users can perform the following tasks in the minimum amount of time and by using the minimum amount of development effort:
-Browse through the report offline.
-View the KPIs that they want to see.

Which tool should you use?