CompTIA Data+ (DA0-001) — Question 100

Which of the following is the best technique for transferring data from one database to another with some data manipulation?

Answer options

• A. Application programming interfaces
• B. Delta load
• C. Extract, transform, load
• D. Export/import

Correct answer: C

Explanation

The correct answer is C, Extract, transform, load, as it specifically involves extracting data from one source, transforming it as needed, and loading it into another destination. Options A and D do not inherently include data manipulation, and B, Delta load, typically refers to transferring only the changes since the last load, which may not involve data transformation.