70-448 · Question #66
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named…
The correct answer is D. ALTER MINING STRUCTURE [Bike Buyer]ADD MINING MODEL [Decision Tree] ( [Customer Key]. See the full explanation below for the reasoning.
Question
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server 2008 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?
Options
- AINSERT INTO [Decision Tree] ( [Customer Key], [Age], [Bike Buyer], [Commute Distance],
- BSELECT * INTO [Decision Tree]USING [Microsoft_Decision_Trees]FROM [Bike Buyer]
- CCREATE MINING MODEL [Decision Tree] ( [Customer Key] LONG KEY, [Age] LONG DISCRETIZED
- DALTER MINING STRUCTURE [Bike Buyer]ADD MINING MODEL [Decision Tree] ( [Customer Key],
How the community answered
(25 responses)- A4% (1)
- B12% (3)
- C4% (1)
- D80% (20)
Community Discussion
No community discussion yet for this question.