MCQOPTIONS
Saved Bookmarks
| 1. |
You work as a database administrator for Abc.com. You are in the process of developing a model of data mining by using the SQL Server 2008 Analysis Services (SSAS). In order to develop a structure you use the listed Data Mining Extensions (DMX) code:CREATE MINING STRUCTURE [Abc] ([User Key] LONG KEY,[Total Age] LONG DISCRETIZED (Automatic,20),[Abc] LONG DISCRETE,[Distance] TEXT DISCRETE,[Monthly Income] DOUBLE CONTINUOUS) You need to develop the mining model that will use the above structure and in addition also use Microsoft algorithm. What should you do? |
| A. | You should consider inserting the following code: ALTER MINING STRUCTURE [Abc] ADD MINING MODEL [Decision Tree] ([User Key], [Total Age], [Abc] PREDICT, [Distance], [Monthly Income]) |
| B. | You should consider inserting the following code: INSERT INTO [Decision Tree] ([User Key], [Abc], [Monthly Income]) OPENQUERY ([Abc],Select [User Key], [Abc], [Monthly Income]) |
| C. | You should consider inserting the following code: SELECT * FROM [Decision Tree] USING [Microsoft_Decision_Trees] FROM [Decision Tree]] |
| D. | You should consider inserting the following code |
| Answer» B. You should consider inserting the following code: INSERT INTO [Decision Tree] ([User Key], [Abc], [Monthly Income]) OPENQUERY ([Abc],Select [User Key], [Abc], [Monthly Income]) | |