Question 430
A financial ingest pipeline receives strings representing amounts, dates and identifiers. The change record shows Store and transform the identifier as STRING. The acceptance test concerns: Product IDs contain meaningful leading zeroes and must not be normalized to integers. Which outcome confirms it?
Explanation
Correct Answer
The acceptance criterion for “Product IDs contain meaningful leading zeroes and must not be normalized to integers” is The curated ID preserves prefixes and leading zero digits; this is the expected evidence after Store and transform the identifier as STRING.
Incorrect Answers
A test spanning daylight-saving transition maps to the correct UTC instant pertains to a different control (Parse timestamps with the declared source time zone and normalize to UTC) and a different need (Event timestamps need a consistent UTC interpretation before time-window aggregation). It cannot establish that Store and transform the identifier as STRING met the stated goal.
That observation is a valid indicator for “Critical currency values must reject malformed numeric input rather than silently become zero” when using Apply strict cast validation and route invalid records to a failure path. The scenario instead tests “Product IDs contain meaningful leading zeroes and must not be normalized to integers”; the relevant result is The curated ID preserves prefixes and leading zero digits.
This signal belongs to the adjacent case “A decimal calculation needs fixed financial precision rather than binary floating-point drift,” whose remedy is Use an appropriate DECIMAL precision and scale. The observed result for the present requirement is The curated ID preserves prefixes and leading zero digits.