CompTIA Data+ (DA0-001) — Question 233

Which of the following data integration concepts should be used if only new data is being added to a table since the previous load?

Answer options

• A. Extract, transform, load
• B. Extract, load, transform
• C. Delta load
• D. Application programming interface

Correct answer: C

Explanation

The correct answer is C, Delta load, which specifically refers to the process of loading only the data that has changed or been added since the last load. The other options, such as Extract, transform, load and Extract, load, transform, involve loading all data or transforming it before loading, which is not suitable when only new data is present.