You need to build a daily aggregation table for reporting, but late-arriving events can appear 2 to 3 days after the original event date. How would you design the pipeline so the aggregates remain accurate over time?
Write your answer in the field below and click the "Check!" button.