Materialize It, or Not — With NumbersWarehouse · hard · ~15 minThe exec revenue dashboard hits one heavy aggregation ~500 times/day; each run costs ~0.2 credits and takes 9 seconds (analysts complain). Proposal A: leave it. Proposal B: materialize it (hourly refresh ≈ 1.5 credits per refresh; dashboard then reads the materialization at ~0.01 credits in <1s). Proposal C from an intern: 'why not refresh every minute so it's always fresh?'Credits are $3. Decide with arithmetic — including the staleness contract and the intern's math.Evidence

Workload

Numbers

Checkpoints

Option B saves how many CREDITS per day vs today? (100 − 41)

The intern's every-minute refresh (C): what's wrong with it?

What makes materialization the WRONG choice in general?

Write the recommendation including the staleness CONTRACT and the check-back. Interview-style.