Skip to interview prep
Apexed

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
A daily report disagrees with order history near midnight. How would you isolate the discrepancy — Software engineering interview question — Apexed