DRAG DROP
You are developing a SQL Server PowerPivot model to monitor the rate of production of
defective products.
The PowerPivot model contains many tables. The FactProduction table is configured as
shown in the following diagram.
The model requires a key performance indicator (KPI) named Defective Units to measure
the rate of production of defective units. The rate of production of defective units is
calculated by dividing the sum of the Defects column by the sum of the Units column.
The KPI has the following requirements.
If the rate of production of defective products equals or exceeds 5% then the KPI must report
a status of off target (red).
If the rate of production of defective products is less than 5% and equals or exceeds 2%
then the KPI must report a status of slightly off target (yellow).
If the rate of production of defective products less than 2% then the KPI must report a status
of on target (green).
You need to develop the KPI to meet the requirements.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
Answer: 
Answer :
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image027.jpg
yes
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image0211.jpg
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image0232.jpg
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image0251.jpg
1. Create a measure named Defective Units to divde the SUM of the Defect column by the SUM of the Units column
2. Create a KPI based on the Defective Units measure.
3. Configure the KPI to use the Defective Units measure as the target value. Select the Green-Yellow-Red threshold band. Configure the threshold values to 2% and 5%
I agree.
Exactly!
I agree as well
A linked measure group can only use a linked dimension from the same source database . So need to get a measure group and associated dimension.
I agree with Python
Agree measure group and dimension else there is no point to link Measure group
Rethink again; according to following link, select on the Measure Group that you need to link could actually also work.
https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/linked-measure-groups
The measures contained in a linked measure group can be directly organized only along linked dimensions retrieved from the same Analysis Services database. However, you can use calculated members to relate information from linked measure groups to the other, non-linked dimensions in your cube. You can also use an indirect relationship, such as a reference or many-to-many relationship, to relate non-linked dimensions to a linked measure group.