Through utilizing SQL Server 2008 Analysis Services (SSAS) for Company.com,you are developing a model of data mining.
Through utilizing the listed Data Mining Extensions (DMX) codes, you could develop a structure
CREATE MINING STRUCTURE [Clerk Maker] ( [User Key] LONG KEY,[Total Age] LONG DISCRETIZED (Automatic,20),[Clerk Maker] LONG ISCRETE,[Distance] TEXT DISCRETE,[Monthly Income] DOUBLE CONTINUOUS)
Not only should you develop a mining model which could be operated through utilizing this structure, but also you should make sure that the model utilizes the Microsoft algorithm.
Which is the correct answer?
A.
You should add codes below:
ALTER MINING STRUCTURE [Clerk Maker] ADD MINING MODEL [Decision Tree] ([User Key], [Total Age], [Clerk Maker] PREDICT, [Distance], [Monthly Income])
B.
You should add codes below:
INSERT INTO [Decision Tree] ([User Key], [Clerk Maker], [Monthly Income]) OPENQUERY ([Clerk Maker],’Select [User Key], [Clerk Maker], [Monthly Income]’)
C.
You should add codes below: SELECT * FROM [Decision Tree] USING [Microsoft_Decision_Trees] FROM [Decision Tree]]
D.
You should add codes below: SELECT * FROM [Decision Tree] USING [Microsoft_Decision_Trees] FROM [Clerk Maker]