You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes several SQL Server 2008 Integration Services (SSIS) packages. The SSIS packages import data from files located on other servers.
The packages will be deployed to a SQL Server 2008 instance and scheduled to run through the SQL Server Agent service. The SQL Server Agent service runs under a local user account. The SSIS packages fail to run when the SQL Server Agent jobs are executed. You need to ensure that the packages run successfully in the production environment.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. A SQL Server 2008 Reporting Services (SSRS) instance contains a report. Employees execute the report by using Report Manager.
Each employee has his own specific set of parameters to execute the report. Data for the report is updated once daily. For each employee, the report takes more than five minutes to execute. You discover that data retrieval takes most of the time during report execution. You need to reduce the execution time of the report.
What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. Your solution includes relational and analysis services.
The solution has a cube that is queried by more than 650 users. During peak hours, more than 100 active connections are open on the cube at any given time. Users connect to and query the cube by using custom-built applications. You need to view the connection details and the application name that is used to connect to the cube of all users. What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You deploy a SQL Server 2008 Analysis Services (SSAS) cube. The cube contains a measure group that uses table binding. The measure group contains 200 million rows. A job that processes the measure group fails. The log shows an out-of-memory error. The job uses the Process Update option.
You need to resolve the error. You need to perform this action without increasing the available physical memory for the SSAS instance. What should you do?

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?