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.)
Select and Place:

Answer:

Explanation:
Note:
* (Step 1, step 2): 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.
* Step 3: 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).