Microsoft Azure Data FundamentalsDescribe core data conceptsEasy
A data engineer needs to move data from an on-premises SQL Server database to Azure Synapse Analytics for large-scale analytical processing. The process involves extracting data from the source, performing transformations (e.g., data cleansing, aggregation, format conversion), and then loading the transformed data into the destination. Which data processing option describes this sequence of operations?
- AOnline Transaction Processing (OLTP)
- BExtract, Transform, Load (ETL)
- COnline Analytical Processing (OLAP)
- DStream Processing
Show answer & explanationAnswer & explanation
Correct answer: B. Extract, Transform, Load (ETL)
The process described – extracting data from a source, transforming it, and then loading it into a destination for analytics – is the definition of Extract, Transform, Load (ETL).
Why the other options are wrong
- A. OLTP is for transactional operations, not data movement and transformation for analytics.
- C. OLAP is a type of analytical workload, not a data integration process.
- D. Stream processing is for real-time data in motion, not batch data movement from an on-premises database.
Extract, Transform, Load (ETL)
A three-phase data integration process used to combine data from multiple sources into a single, consistent data store for analysis.
- Extract: Reading data from source systems.
- Transform: Converting data into a suitable format for the destination.
- Load: Writing the transformed data into the target system (e.g., data warehouse).
Memory trick: ETL: Extract, Transform, Load, the Data Flow Road