You design a Business Intelligence (BI) solution by using SQL Server 2008. You design a SQL Server 2008 Reporting Services (SSRS) report that meets the following requirements:
-Displays sales data for the last 12 months.
-Enables users to view the sales information summarized by month.
-Enables users to view individual sales orders for any given month.

You need to design the report to minimize the impact on bandwidth.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You have developed SQL Server 2008 Reporting Services (SSRS) reports that are deployed on an SSRS instance.
You plan to develop a new application to view the reports. The application will be developed by using Microsoft ASP.NET 3.5.
You need to ensure that the application can perform the following tasks:
-Display available reports in a tree view control.
-Create and manage subscriptions on reports.

What should you do?

You are designing a SQL Server 2008 Reporting Services (SSRS) solution. You have a report that has several parameters that are populated when users execute the report. You need to ensure that the solution meets the following requirements:
-Users can define their own default parameter values for the report.
-Users can schedule snapshots at any time.

Which feature should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to develop SQL Server 2008 Reporting Services (SSRS) reports. Several reports will contain identical data regions.
You need to minimize the amount of maintenance when changes are made to the data regions.
What should you do?

You design a SQL Server 2008 Reporting Services (SSRS) solution. The solution contains a report. The report includes information that is grouped into hierarchical levels. You need to ensure that the solution meets the following requirements:
When you click each level, the next level of information must be displayed. When you click the last level, detailed information must be displayed. When the report is exported to a Microsoft Excel spreadsheet, all the levels and all detailed information must be available in the spreadsheet.
Which feature should the report use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. Employees use a Windows Forms application based on Microsoft .NET Framework 3.5. SQL Server is not installed on the employees’ computers.
You write a report by using Report Definition Language (RDL). You need to ensure that if the employees are disconnected from the corporate network, the application renders the report.
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) database. A cube in the database contains a large dimension named Customers. The database uses a data source that is located on a remote server.
Each day, an application adds millions of fact rows and thousands of new customers. Currently, a full process of the cube takes several hours. You need to ensure that queries return the most recent customer data with the minimum amount of latency.
Which cube storage model should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution contains a SQL Server 2008 Analysis Services (SSAS) database. A measure group in the database contains log entries of manufacturing events. These events include accidents, machine failures, production capacity metrics, and other activities. You need to implement a data mining model that meets the following requirements:
-Predict the frequency of different event types.
-Identify short-term and long-term patterns.
Which algorithm should the data mining model use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes a SQL Server 2008 Analysis Services (SSAS) database. The database contains a data mining structure that uses a SQL Server 2008 table as a data source. A table named OrderDetails contains detailed information on product sales. The OrderDetails table includes a column named Markup.
You build a data mining model by using the Microsoft Decision Trees algorithm. You classify Markup as discretized content. The algorithm produces a large number of branches for Markup and results in low confidence ratings on predictable columns. You need to verify whether the Markup values include inaccurate data. What should you do?

You design a SQL Server 2008 Reporting Services (SSRS) solution. You create a report by using Microsoft Visual Studio .NET 2008.
The report contains the following components:
A dataset named Customer that lists all active customers and their details. The dataset accepts no parameters. A dataset named SalesHistory that lists all sales transactions for a specified time period and accepts year and month as parameters.You need to ensure that a summary of sales transactions is displayed for each customer after the customer details.
Which component should you add to the report?