You create a data mining model by using SQL Server 2008 Analysis Services (SSAS).
You create a mining structure by using the following Data Mining Extensions (DMX) code.
CREATE MINING STRUCTURE [Bike Buyer](
[Customer Key] LONG KEY,
[Age] LONG DISCRETIZED(Automatic, 10),
[Bike Buyer] LONG DISCRETE,
[Commute Distance] TEXT DISCRETE,
[Yearly Income] DOUBLE CONTINUOUS
)
You need to create a mining model that can be processed by using this mining structure.
You also need to ensure that the model uses the Microsoft Decision Trees algorithm.
Which DMX statement should you use?
A.
SELECT * INTO [Decision Tree]
USING [Hicrosoft_Decision_Trees]
FROM [Bike Buyer]
B.
CREATE MINING MODEL [Decision Tree] (
[Customer Key] LONG KEY,
[Age] LONG DISCRETIZED(Automatic, 10),
[Bike Buyer] LONG DISCRETE,
[Commute Distance] TEXT DISCRETE,
[Yearly Income] DOUBLE CONTINUOUS
) USING Microsoft_Decision_Trees
C.
ALTER MINING STRUCTURE [Bike Buyer]
ADD MINING MODEL [Decision Tree] (
[Customer Key] ,
[Age],
[Bike Buyer] PREDICT,
[Commute Distance],
[Yearly Income]
) USING Microsoft_Decision_Trees
WITH DRILLTHROUGH
INSERT INTO [Decision Tree]
(
[Customer Key], [Age],
[Bike Buyer], [Commute Distance],
[Yearly Income]
)
OPENQUERY ([Bike Buyer],
‘Select [Customer Key], [Age],
[Bike Buyer] , [Commute Distance],[Yearly Income]’
)
Explanation: