問題文
Management asks for a five-year trend of month-end stock levels per warehouse. The detail rows behind those levels are numerous enough that holding five years of them is not affordable, and the trend itself needs only one figure per warehouse per month. How should the long-term trend be preserved?
選択肢
- Schedule a reporting snapshot that writes the month-end figures into a custom object, then archive or purge the detail rows behind them.
- Export the detail rows to spreadsheets every month and keep the files outside the platform, because the trend can be rebuilt by hand from those files whenever management asks for it, so nothing has to be stored in the platform at all.
- Keep every detail row and let the report compute the trend on each run, and buy additional storage each year as it is needed.
- Move the detail rows into a big object and build the trend report from there, since a big object holds history cheaply and reports read it in the same way, and the detail rows stay available for drill-down.