Question 470
A wholesale business reconciles multiple source feeds against a reporting Delta mart. Engineers have applied Detect the unit change and apply explicit normalization before aggregation. Which result establishes the required behavior: An upstream source changes the amount column from cents to major currency units?
Explanation
Correct Answer
A known invoice fixture yields the expected standardized revenue amount is the matching outcome for the implemented control (Detect the unit change and apply explicit normalization before aggregation) and the stated requirement “An upstream source changes the amount column from cents to major currency units.”
Incorrect Answers
Store-level net revenue equals the validated reference calculation would demonstrate the separate action Normalize missing-discount semantics according to the data contract, which addresses “Different stores encode null discount fields inconsistently.” It does not verify the requirement “An upstream source changes the amount column from cents to major currency units” following Detect the unit change and apply explicit normalization before aggregation.
That observation is a valid indicator for “A report must compare two monetary datasets with a small specified numeric tolerance” when using Compute per-key differences and flag only values outside the tolerance. The scenario instead tests “An upstream source changes the amount column from cents to major currency units”; the relevant result is A known invoice fixture yields the expected standardized revenue amount.
This signal belongs to the adjacent case “A retrying source double-delivers payments with the same payment event ID,” whose remedy is Deduplicate on the unique payment event ID before aggregation. The observed result for the present requirement is A known invoice fixture yields the expected standardized revenue amount.