You create a data mining model by using SQL Server 2008 Analysis Services (SSAS).
You create a mining structure by using the following Data Mining Extensions (DMX) code.
CREATE MINING STRUCTURE [Bike Buyer](
[Customer Key] LONG KEY,
[Age] LONG DISCRETIZED(Automatic, 10),
[Bike Buyer] LONG DISCRETE,
[Commute Distance] TEXT DISCRETE,
[Yearly Income] DOUBLE CONTINUOUS
)
You need to create a mining model that can be processed by using this mining structure.
You also need to ensure that the model uses the Microsoft Decision Trees algorithm.
Which DMX statement should you use?

You develop a SQL Server 2008 Analysis Services (SSAS) database. Your database
includes several measure groups.
A measure group named Sales Data requires frequent updates than other measure groups.
You need to ensure that the Sales Data measure group will automatically process on a
schedule managed by SSAS.
What should you do?

You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has the
following components:
A hierarchy named Date in a time dimension named DimTime
A measure named SalesAmount
You add the following code segment to the calculation script of the cube. (Line numbers are
included for reference only.)
01 . . .
02 Freeze([Measures].[SalesAmount],
03 [DimTime].[Date].[Quarter].[Q1 2007]);
04 . . .
You need to increase the value of the SalesAmount measure by 50% for each month in the
first quarter of 2007.
You also need to ensure that the value for the first quarter of 2007 remains unchanged.
What should you do?

You create a SQL Server 2008 Analysis Services (SSAS) solution.
You create a dimension named Customer. The Customer dimension has the attributes
named Country and State.
The Country attribute has the following components:
The KeyColumn property is set to the country code.
The NameColumn property is set to the country name.
You create an attribute relation between the Country attribute and the State attribute.
You need to ensure that the state names are sorted first by the country name and then by
the state name.
What should you do?

You create a SQL Server 2008 Analysis Services (SSAS) solution by using SQL Server
2008.
You create the dimensions as shown in the following table.

The CustKey attribute is used as a column in a table named FactSales.
You need to create a referenced dimension that allows you to browse the measures of the
FactSales table by using the DimGeography dimension.
What should you do?

You create a SQL Server 2008 Analysis Services (SSAS) solution.
You add a data source view (DSV) to the solution. The DSV has a table named Employee
that includes the following columns:
EmployeeKey
ManagerKey
The ManagerKey column references the manager of the employees.
You need to define the relationship between the employees and their manager in the DSV.
What should you do?

You create a SQL Server 2008 Analysis Services (SSAS) solution.
The solution contains a time dimension named DimTime. You have a table named FactSales
that contains the two columns named OrderDate and ShipDate. The two columns refer to the
DimTime dimension.
You need to ensure that the DimTime dimension can be used to browse through measures
in the
FactSales table for both OrderDate and ShipDate.

What should you do?

You are creating a SQL Server 2008 Integration Services (SSIS) package for Company.com.
The SSIS package must contain six Data Flow tasks and three Control Flow tasks.
You should alter the package .Which is the correct answer?

You are managing a SQL Server 2008 Reporting Services (SSRS) sample which does not
give some same rendering extensions for Company.com.
You should make sure that you could set the server in order to render to Microsoft Word.
Which is the correct answer?

You are creating a SQL Server 2008 Integration Services (SSIS) package on a SQL Server
2008 database for Company.com. In order to develop a failure recovery plan that is
published for a SQL Server. Which is the correct answer?