Microsoft Exam Questions

Which is the correct answer?

You are running a SQL Server 2008 Analysis Services (SSAS) solution which contains data
mining extensions (DMX) to search a data mining model for Company.com.
In order to search a Clerk Walker data mining model in a Decision Tree data mining
structure, the codes are listed below:
11 SELECT
12 [Decision Tree].[Clerk Walker] AS Buyer
13 FROM
14 [Decision Tree]
15
16 (SELECT 28 AS [Age],
17 ‘2-5 Miles’ AS [Commute Distance],
18 ‘1’ AS [House Owner Flag],
19 1 AS [Number Cars Owned],
20 2 AS [Total Children]) AS t
In the data mining structure, you should make sure that the input columns map to the
columns. Which is the correct answer?

A.
You should utilize NATURAL PREDICTION JOIN

B.
You should utilize LEFT JOIN

C.
You should utilize OUTER JOIN

D.
You should utilize RIGHT JOIN