Which of the following best describes a scenario where a full load would be preferred over an incremental load?

When you need to maintain historical data in the data warehouse
When you need to update the warehouse frequently
When you want to keep storage costs low
When you want to reduce data processing time

A full load is preferred over an incremental load when you need to maintain historical data in the data warehouse. Incremental loads are typically used for efficiency, but when historical data must be preserved, a full load is necessary to capture all records accurately.

Add your answer