CAF-3 · Chapter 6 · Question 10 of 15
To save processing time and bandwidth, a company updates its data warehouse every midnight by only bringing in the new transactions that occurred that specific day, rather than reloading the entire 5-year history. This method is known as:
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: C) Incremental loading
Explanation
Incremental loading in ETL refers to adding only new or updated records to the data warehouse, which is much faster than doing a full data load . --------------------------------------------------------------------------------
More Data Warehouse Schemas & Data Marts MCQs
- Q12To save storage space and ensure stricter data integrity, a database engineer modifies a Star Schema by breaking down the 'Product'…
- Q13An enterprise wants to integrate its 'Sales' process and its 'Inventory' process into one analytical model. The database designer creates…
- Q14What is the primary trade-off between choosing a Star Schema versus a Snowflake Schema for a data warehouse?
- Q15The Marketing Department of a large corporation finds the main enterprise data warehouse too massive and slow for their specific daily…
- Q1An organization’s customer database frequently suffers from update anomalies because the same customer’s address is stored in multiple…