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?

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes reports hosted on a single SQL Server 2008 Reporting Services (SSRS) server. You plan to modify the report server infrastructure to support a scale-out deployment. You need to ensure that the scale-out deployment meets the following requirements:
-Allows users to access any of the Report Server servers by using the original Report Manager URL.
-Minimizes network traffic.

Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to deploy a new SQL Server 2008 Reporting Services (SSRS) solution for an accounting department. The department currently uses Microsoft Excel 2007based reports hosted on Windows SharePoint Services (WSS) 3.0.
You need to replace the existing Excel 2007 reports with SSRS-based reports.
Your solution must meet the following requirements:
-Users must be able to access the reports by using WSS.
-Reports must be version-controlled.
-Developers must be able to deploy the reports to a WSS document library.

Which two tasks should you perform? (Each correct answer presents part of the solution. Choose two.)

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution will support a Microsoft ASP.NET application that is deployed to a Web farm. Reports will be deployed to a SQL Server 2008 Reporting Services (SSRS) instance. The databases for the SSRS instance will be deployed to a two-node failover cluster that hosts a single instance of SQL Server 2008.
You need to ensure that the SSRS instance remains available even when one of the servers fails.
What should you do?

You administer a SQL Server 2000 server.
The SQL Server 2000 server hosts a SQL Server 2000 relational data warehouse and a SQL Server 2000 Analysis Services database (OLAP database).
You plan to migrate to a new SQL Server 2008 server in a new untrusted domain. You need to ensure that both the relational data warehouse and the OLAP database are migrated in the minimum possible time.
What should you do?