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.)
