Microsoft
70-448 · Question #66
70-448 Question #66: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #66. The question stem and answer options stay visible for context.
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],
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.