You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008. Now you are employed in a
company which is named NaproStar and work as the technical support for the company
which uses SQL Server2008 Analysis Services (SSAS). To meet the business development,
(SSAS) is used to create a data mining model and the Data Mining Extensions (DMX) code
is used to create a mining structure.
The Data Mining Extensions (DMX) code is shown as the following:
Now you are assigned the following tasks:
Make sure that the Microsoft Decision Trees algorithm is used by the model. Have a mining
model that can be processed by this mining structure created.
So of the following DMX statements, which one should be used to accomplish the tasks
above?
A.
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]’)
B.
SELECT * INTO [Decision Tree]USING [Microsoft_Decision_Trees]FROM [Bike Buyer]
C.
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
D.
ALTER MINING STRUCTURE [Bike Buyer]ADD MINING MODEL [Decision Tree] (
[Customer
Key], [Age], [Bike Buyer] PREDICT, [Commute Distance], [Yearly Income]) USING
Microsoft_Decision_TreesWITH DRILLTHROUGH