You design a SQL Server 2008 Analysis Services (SSAS) solution. The solution includes a mining structure that is created by using the default options and a mining model that uses the Microsoft Clustering algorithm. You need to ensure that users can access source data by querying the mining model. What should you do?
A.
Modify the mining structure to include a filter.
B.
Modify the mining structure to enable drillthrough.
C.
Include a task in the solution to process the mining model.
D.
Include a task in the solution to delete all cached data from the mining model.
Explanation:
Tip: "Microsoft Clustering algorithm" = "drillthrough"Microsoft Clustering algorithm
Function
The Microsoft Clustering algorithm builds clusters of entities as it processes the training data set. It looks at the values of each attribute for the entities in the cluster. By entering the attribute value we want, we can have the clusters color-coded according to the concentration of our desired value.
Tasks
The main purpose of the Microsoft Clustering algorithm is
– Segmentation
It can also be used for
– Regression
– Classification
(McGraw-Hill – Delivering Business Intelligence with Microsoft SQL Server 2008 (2009))Microsoft Clustering Algorithm
As its name indicates, the Microsoft Clustering algorithm focuses on showing you meaningful groupings in your source data. Unlike Na?ve Bayes, which requires discrete content inputs and
considers all input attributes of equal weight, Microsoft Clustering allows for more flexibility in input types and grouping methodologies. You can use more content type as input and you
can configure the method used to create the groups or clusters. Microsoft Clustering separates your data into intelligent groupings. As we mentioned in the previous paragraph, you can use Continuous, Discrete, and most other content types. You can optionally supply a predictive value, by marking it as predict only. Be aware that Microsoft Clustering is generally not used for predictionyou use it to find natural groupings in your data.
(Smart Business Intelligence Solutions with Microsoft SQL Server 2008, Copyright 2009 by Kevin Goff and Lynn Langit)Drillthrough Action Defines a dataset to be returned as a drillthrough to a more detailed level.
Creating Drillthrough Actions
For the most part, Drillthrough Actions have the same properties as Actions. Drillthrough Actions do not have Target Type or Target Object properties. In their place, the Drillthrough Action has the following:
– Drillthrough Columns Defines the objects to be included in the drillthrough dataset.