DA0-001 · Question #173
Which of the following is the best technique for transferring data from one database to another with some data manipulation?
The correct answer is C. Extract, transform, load. The Extract, Transform, Load (ETL) process is the most effective technique for transferring data between databases when data manipulation is a necessary part of the transfer.
Question
Which of the following is the best technique for transferring data from one database to another with some data manipulation?
Options
- AApplication programming interfaces
- BDelta load
- CExtract, transform, load
- DExport/import
How the community answered
(40 responses)- A3% (1)
- B5% (2)
- C90% (36)
- D3% (1)
Why each option
The Extract, Transform, Load (ETL) process is the most effective technique for transferring data between databases when data manipulation is a necessary part of the transfer.
Application Programming Interfaces (APIs) are methods for software components to interact but do not inherently provide a complete process for data transfer with built-in manipulation for large database movements.
ETL involves three stages: extracting data from the source, transforming it to meet business rules or data quality standards (which includes manipulation), and then loading it into the target database. This structured approach is ideal for complex data migrations requiring manipulation.
Concept tested: Data integration - ETL process
Source: https://learn.microsoft.com/en-us/azure/architecture/guide/architecture-styles/big-data-architecture-etl
Topics
Community Discussion
No community discussion yet for this question.