get the app get the app       get the app       get the app


Question: 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?

1)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])
2)You should consider inserting the following code: INSERT INTO [Decision Tree] ([User Key], [Abc], [Monthly Income]) OPENQUERY ([Abc],Select [User Key], [Abc], [Monthly Income])
3)You should consider inserting the following code: SELECT * FROM [Decision Tree] USING [Microsoft_Decision_Trees] FROM [Decision Tree]]
4)You should consider inserting the following code: SELECT * FROM [Decision Tree] USING [Microsoft_Decision_Trees] FROM [Abc]


Previous Next
Exam


Suggest other answer
Login to Discuss/suggest the answer...

Exam Exam: 70-448 MS SQL Server 2008, Business Intelligence





Recommended Learning for you

Close(X)
Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material