Question 500
A stakeholder needs evidence that the following design achieved its goal: A KPI model retains ten years of detailed events though current requirements only need the last two years. The design uses Apply supported source filtering or a documented retention window to remove unneeded historical rows. What is the strongest validation?
Explanation
Correct Answer
This checks the actual result rather than a saved setting. Row reduction is appropriate only when the dropped history is outside business requirements. A failed implementation may show: Dropping history without validating regulatory or report needs creates unsupported data loss.
Incorrect Answers
Model size and visual load time decrease while reconciled measures remain correct. However, this does not establish the required outcome: required reports preserve correct results over the approved period with a smaller model.
The table can render permitted URL values as navigable links. However, this does not establish the required outcome: required reports preserve correct results over the approved period with a smaller model.
Drill-down changes from regional aggregates to member stores with expected filtering. However, this does not establish the required outcome: required reports preserve correct results over the approved period with a smaller model.