You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution has been deployed by using default settings on a SQL Server 2008 Analysis Services (SSAS) instance. The solution has a large cube that processes 10 million fact rows. You frequently encounter out-of-memory exceptions when the cube is processed. You need to recommend a solution to resolve the out-of-memory exceptions when the cube is processed. You want to achieve this task by using the minimum amount of development effort.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. Your solution includes a data mining structure that uses SQL Server 2008 Analysis Services (SSAS) as its data source. The measure groups use 100 percent multidimensional online analytical processing (MOLAP) storage.
You need to provide detailed information on the training and test data to ensure the accuracy of the mining model. You also need to minimize the time required to create the training and test data. 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. Your company processes all transaction data in a Point of Sale (POS) application. Based on the transaction data, you design a solution to predict the type of products a customer tends to purchase on a single visit.
You need to identify the appropriate algorithm to design the solution.
Which algorithm should you use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes a SQL Server 2008 Analysis Services (SSAS) database.
A measure group in the database contains transaction details. The transaction details include the price, volume of shares, trade type, and several other attributes of each transaction. You need to implement a data mining model that will estimate the future prices based on the existing transaction data.
Which algorithm should the data mining model use?

You design a Business Intelligence (BI) solution by using SQL Server 2008. A data warehouse named CustomerDW contains a Fact table named FactCustomer. The FactCustomer table contains two columns named CustomerKey and CustomerSales. You create a data mining model named CustomerModel by using SQL Server 2008 Analysis Services (SSAS).
A report that is developed by using SQL Server 2008 Reporting Services (SSRS) lists the top 50 customers based on the sales amount. The report extracts data from a SQL Server relational database.
You add a column named UpSell to the report.
You need to ensure that the UpSell column displays the probability values of the expensive products that customers are likely to purchase.
Which Data Mining Extensions (DMX) query should you use?

You design a SQL Server 2008 Analysis Services (SSAS) solution. The solution includes a mining structure that is created by using the default options and a mining model that uses the Microsoft Clustering algorithm. You need to ensure that users can access source data by querying the mining model. What should you do?

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?