You design a SQL Server 2008 Analysis Services (SSAS) solution. You have the following requirements for a single data mining model:
-Group all customers by two different age ranges.
-Group all customers by ten different age ranges.

You need to design the model to meet the requirements.
What should you include in the design?

You are a SQL Server 2008 Analysis Services (SSAS) data mining architect. The customer table contains the following column names:
-Customer_key
-Name
-Age
-Education Level
-IsBuyer

You plan to build a data mining model by using Microsoft Decision Trees algorithm for the customer table.
You need to identify the data columnmodel parameter pairs to predict possible buyers.
Which model should you select?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services (SSRS) solution. The solution has a report named SalesDetails that contains a parameter named EmployeeID .
You have the following constraints:
-Ten thousand employees require the report in different file formats.
-The employees can view only their sales data by specifying their identity number as the EmployeeID parameter.

You need to ensure that the constraints are met before you deliver the report to the employees. What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services (SSRS) solution. Developers generate random reports against a data source that contains 200 tables. Power users generate random reports against four of the 200 tables. You need to design a strategy for the SSRS solution to meet the following requirements:
-Uses minimum amount of development effort.
-Provides two sets of tables in SSRS to the developers group and the power users group.

Which strategy should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services (SSRS) report.
The report contains summary information in two sections named Agencies and States. The Agency summary section contains two matrices and the State summary section contains a table. The information about each section is grouped together.
You need to design the report to meet the following requirements:
-When the report is exported to a Microsoft Excel spreadsheet, each summary section is rendered to a separate tab.
-The structure in each section is retained.

What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services (SSRS) solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee.
Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee.
You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution will contain a total of 100 different reports created by using Report Definition Language (RDL).
Each report must meet the following requirements:
-Display a common set of calculations based on a parameter value.
-Provide a method for setting values on a report URL or in a subscription definition that are not exposed to a user.
-The business rules for all reports that determine the calculations change frequently.

You need to design a solution that meets the requirements. You need to perform this action by using the minimum amount of development and maintenance effort.
What should you do?

You are creating a SQL Server 2008 Reporting Services (SSRS) solution for a company that has offices in different countries. The company has a data server for each country. Sales data for each country is persisted in the respective data server for the country. Report developers have only Read access to all data servers. All data servers have the same schema for the database.
You design an SSRS solution to view sales data.
You need to ensure that users are able to easily switch between sales data for different countries.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services (SSRS) report. The report must display the list of orders placed through the Internet.
You need to ensure that the following requirements are met:
-The amount of time required for processing the report is minimal.
-The report contains the most recent data at the end of each business day.
-A report is available for any of the last seven days.

Which type of report should you create?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a sales report by using SQL Server 2008 Reporting Services (SSRS). The report is used by managers in a specific country.
Each manager prints multiple copies of the report that contains the previous day’s sales for each of their sales executives.
You need to ensure that the report uses the minimum number of round trips to the database server.
What should you do?