Question 170
Scenario pair: The first request is: A KPI model retains ten years of detailed events though current requirements only need the last two years. Separately, another team needs: A yearly expense budget contains one row per Department-Year and actual spending is at Department-Date grain. Select TWO appropriate approaches.
Explanation
Correct Answers
This fulfills requirement B. Facts of different grains should be compared at a compatible aggregation level. Validate by confirming: The variance compares matching fiscal periods without duplicating budget for every transaction.
This fulfills requirement A. Row reduction is appropriate only when the dropped history is outside business requirements. Validate by confirming: Required reports preserve correct results over the approved period with a smaller model.
Incorrect Answers
COUNTROWS evaluates row cardinality in the current filter context. The two requirements instead call for these controls: (A) Apply supported source filtering or a documented retention window to remove unneeded historical rows; (B) Keep budget at its valid year-level grain and aggregate actuals to comparable Department-Year level for variance reporting.
A bridge fact is suitable for many-to-many events with their own grain and attributes. The two requirements instead call for these controls: (A) Apply supported source filtering or a documented retention window to remove unneeded historical rows; (B) Keep budget at its valid year-level grain and aggregate actuals to comparable Department-Year level for variance reporting.
A proper date dimension should have a continuous distinct date column. The two requirements instead call for these controls: (A) Apply supported source filtering or a documented retention window to remove unneeded historical rows; (B) Keep budget at its valid year-level grain and aggregate actuals to comparable Department-Year level for variance reporting.