"What Kind of Fact Table Would You Use?"

Classify in 30 Seconds: The Interviewer Is Timing You The 60-Second Framework Step 4 bridges to the Additive Measures pattern. Naming additivity unprompted when you define measures shows the interviewer you are thinking about how this table will be aggregated, not just how it will be loaded. Why Companies Care Cite these in your answer: 'At Uber, the ride fact was a transaction. When the business needed lifecycle tracking (requested, assigned, in-progress, completed, canceled), a transaction fact could not represent intermediate states. Migrating to an accumulating snapshot required reprocessing 2 years of data.' Drop this in 10 seconds. It proves you have seen the wrong fact type chosen and know the migration cost.