Microsoft Azure Data Fundamentals — Question 207

Which service can be used to build extract, transform, and load (ETL) pipelines?

Answer options

• A. Azure Data Factory
• B. Azure Pipelines
• C. Azure SQL Database
• D. Azure Cosmos DB
• E. Azure Databricks

Correct answer: A

Explanation

Azure Data Factory is specifically designed for building ETL pipelines, allowing users to orchestrate data movement and transformation. Azure Pipelines focuses on CI/CD processes rather than ETL, while Azure SQL Database and Azure Cosmos DB are database services that do not provide ETL capabilities. Azure Databricks is a data analytics platform, which can support ETL but is not primarily an ETL service.