62. A daily report disagrees with order history near midnight. How would you isolate the discrepancy?
MediumDebugging & production
Technical
Show model answer
Compare the exact event timestamps, storage format, reporting time zone and interval boundaries for a small set of disputed orders. Check whether one view uses order creation and the other uses payment completion.
Reproduce with explicit instants on both sides of midnight and a daylight-saving transition where relevant. Agree on the business-day definition, use non-overlapping intervals, and backfill or annotate affected reports after verifying reconciliation totals.
What interviewers listen for
- Compare event definitions
- Explicit time boundaries
- Reconcile affected records