PrepAway - Latest Free Exam Questions & Answers

Which is the correct answer to make sure that the model utilizes the Microsoft algorithm?

Through utilizing SQL Server 2008 Analysis Services (SSAS) for Company.com,you are developing a model of data mining.

Through utilizing the listed Data Mining Extensions (DMX) codes, you could develop a structure

CREATE MINING STRUCTURE [Clerk Maker] ( [User Key] LONG KEY,[Total Age] LONG DISCRETIZED (Automatic,20),[Clerk Maker] LONG ISCRETE,[Distance] TEXT DISCRETE,[Monthly Income] DOUBLE CONTINUOUS)

Not only should you develop a mining model which could be operated through utilizing this structure, but also you should make sure that the model utilizes the Microsoft algorithm.
Which is the correct answer?

PrepAway - Latest Free Exam Questions & Answers

A.
You should add codes below:
ALTER MINING STRUCTURE [Clerk Maker] ADD MINING MODEL [Decision Tree] ([User Key], [Total Age], [Clerk Maker] PREDICT, [Distance], [Monthly Income])

B.
You should add codes below:
INSERT INTO [Decision Tree] ([User Key], [Clerk Maker], [Monthly Income]) OPENQUERY ([Clerk Maker],’Select [User Key], [Clerk Maker], [Monthly Income]’)

C.
You should add codes below: SELECT * FROM [Decision Tree] USING [Microsoft_Decision_Trees] FROM [Decision Tree]]

D.
You should add codes below: SELECT * FROM [Decision Tree] USING [Microsoft_Decision_Trees] FROM [Clerk Maker]


Leave a Reply