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] 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?

Question

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] 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?

Accepted Answer

A. You should utilize NATURAL PREDICTION JOIN

Answer

B. You should utilize LEFT JOIN

Answer

C. You should utilize OUTER JOIN

Answer

D. You should utilize RIGHT JOIN

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…

Question

Options

How the community answered

Community Discussion