You are analyzing a data mining structure by using Business Intelligence Development Studio (BIDS). You change the settings on the Data Mining Accuracy Chart tab. What changes should you expect in both the profit chart and the lift chart?

You are designing a data mining structure for a Microsoft SQL Server 2005 Analysis Services (SSAS) solution. The data mining structure must forecast the day of the month on which a combination of products are most likely to sell. You need to configure properties for the DayofMonth column within a data mining solution. What should you do?

You are designing a Microsoft SQL Server 2005 Analysis Services (SSAS) solution. The SSAS database includes a data mining model that uses the Microsoft Neural Network algorithm. You use Prediction Query Builder in Microsoft SQL Server Management Studio (SSMS) to build the Data Mining Extensions (DMX) queries for the database. You need to write a query that returns the number of cases in the data mining model and the percentage of the sample cases that fit the model. Which Prediction Query Builder field configuration should you use?

You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You want to change the design of the data mining structure to test different data mining theories. You add columns of the Ordered content type in the data mining model and the underlying case table. You need to ensure that Data Mining Viewer reflects the changes in the data mining structure and the data mining model. Which process option should you choose?

You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You deploy a data mining structure that includes the Microsoft Clustering mining model. You need to change the properties of the mining model from Scalable K-Means to Non-scalable K-Means. Which parameter of the mining model should you change?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.

Your data source contains the following tables:

Products table with a column named ProductCategories_ID ProductCategories table with a column named ID The ProductCategories_ID column is used to link to the ID column. You create a data source view with the RetrieveRelationships property set to false.

You need to set the NameMatchingCriteria property of the data source view to an option to create a relationship between the two tables.

Which option should you use?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS)project.You create a

cube that has the following objects:

A dimension named ProductSubcategory that contains a table named DimProductSubcategory.A dimension named Product that contains a table named DimProduct.A fact table named FactInventory.

The relationship between the three tables is shown in the following exhibit. (Click the Exhibit button.)

You need to create a relationship on the Dimension Usage tab to browse through the data in theFactInventory table by using only the ProductSubcategory dimension.
What should you do?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. The project has a fact table named FactOrders that contains columns named Order Amount, Country, and Order Date Key. You create the first partition for the fact table with the Source property set to “Select * from FactOrders where [Order Date Key]>354 or Country=’USA'”. You need to create the second partition for the fact table to ensure accurate results when queried. What should you do?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.
You create a cube with the following objects:

A time dimension named Time.
A fact table that contains two columns named Order Date Key and Numbers of Orders.
A Number of Orders measure added to a measure group named Measures.

The cube has a dimension usage named Order Date that links the Order Date Key column to the Time dimension.

You need to create a Multidimensional Expressions (MDX) calculation that displays the cumulative totals of the Number of Orders column for all hierarchies in the Order Date dimension.

Which MDX expression should you use?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. You create a cube that uses a dimension named DimEmployee. The dimension contains an attribute named Employee. You also host a Microsoft SQL Server 2005 Reporting Services (SSRS) project that contains a parameterized report on an employee. You need to create an action to view the report. What should you do?