70-448 · Question #18
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…
The correct answer is C. ALTER MINING STRUCTURE [Bike Buyer]. See the full explanation below for the reasoning.
Question
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?
Options
- ASELECT * INTO [Decision Tree]
- BCREATE MINING MODEL [Decision Tree] (
- CALTER MINING STRUCTURE [Bike Buyer]
How the community answered
(59 responses)- A7% (4)
- B17% (10)
- C76% (45)
Community Discussion
No community discussion yet for this question.