Oliver is designing an ETL process to copy sales data into a data warehouse on a hourly basis. What approach should Oliver choose that would be most efficient and minimize the chance of losing historical data?
Correct Answer: D
Correct answer D. Delta load Since Oliver needs to migrate changes every hour, a delta load is the best approach.