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]