Question 980
Two departments calculate net revenue differently in dashboards even though both read the same Delta facts. The analytical design uses a governed Unity Catalog metric view. Which continuing control should the team adopt after recovery?
Explanation
Correct Answer
Version metric definitions with finance signoff. This is the most directly relevant preventive control because repeated custom KPI expressions diverge without one approved metric contract. A concrete acceptance check is: Both reports produce identical net revenue for the same filters and date range. To reduce recurrence: Version metric definitions with finance signoff.
Incorrect Answers
Unreconciled identifiers across layers cause inconsistent joins and counts. The reported failure instead depends on this fact: repeated custom KPI expressions diverge without one approved metric contract.
Repeated descriptive attributes in facts complicate history and consistency. That consideration does not remove the current constraint: repeated custom KPI expressions diverge without one approved metric contract.
Cross-format readers rely on maintained snapshot metadata to observe current data. In this situation, repeated custom KPI expressions diverge without one approved metric contract.