PrepAway - Latest Free Exam Questions & Answers

which code fragment should be inserted?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
INNER JOIN

B.
OPENQUERY

C.
PREDICTION JOIN

D.
NATURAL PREDICTION JOIN


Leave a Reply