1.

You work as a database administrator for Abc.com. You are in the process of developing a model of data mining by using the SQL Server 2008 Analysis Services (SSAS). In order to develop a structure you use the listed Data Mining Extensions (DMX) code:CREATE MINING STRUCTURE [Abc] ([User Key] LONG KEY,[Total Age] LONG DISCRETIZED (Automatic,20),[Abc] LONG DISCRETE,[Distance] TEXT DISCRETE,[Monthly Income] DOUBLE CONTINUOUS) You need to develop the mining model that will use the above structure and in addition also use Microsoft algorithm. What should you do?

A. You should consider inserting the following code: ALTER MINING STRUCTURE [Abc] ADD MINING MODEL [Decision Tree] ([User Key], [Total Age], [Abc] PREDICT, [Distance], [Monthly Income])
B. You should consider inserting the following code: INSERT INTO [Decision Tree] ([User Key], [Abc], [Monthly Income]) OPENQUERY ([Abc],Select [User Key], [Abc], [Monthly Income])
C. You should consider inserting the following code: SELECT * FROM [Decision Tree] USING [Microsoft_Decision_Trees] FROM [Decision Tree]]
D. You should consider inserting the following code
Answer» B. You should consider inserting the following code: INSERT INTO [Decision Tree] ([User Key], [Abc], [Monthly Income]) OPENQUERY ([Abc],Select [User Key], [Abc], [Monthly Income])


Discussion

No Comment Found