You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.
Now you receive an e-mail from your company CIO, in the e-mail, the CIO assigns a task to you.
You implement a SQL Server 2008 Analysis Services (SSAS) solution.
In a Decision Tree data mining structure, you query a data mining model by using data mining extensions (DMX). You write the following DMX code segment. (Line numbers are used for reference only.)
1 SELECT
2 [Decision Tree].[Bike Buyer] AS Buyer
3 FROM
4 [Decision Tree]
6 (SELECT 28 AS [Age],
5. …………
7 ‘2-5 Miles’ AS [Commute Distance],
8 ‘1’ AS [House Owner Flag],
9 1 AS [Number Cars Owned],
10 2 AS [Total Children]) AS t
You must make sure that the input columns automatically map to the columns in the data mining structure. At line 5, which code fragment should be inserted?
A.
INNER JOIN
B.
OPENQUERY
C.
PREDICTION JOIN
D.
NATURAL PREDICTION JOIN