AZ-900 Describe Azure architecture and services Practice Question
Which Azure service provides a way to automatically extract and load data from external SaaS applications like Salesforce and ServiceNow into Azure data stores?
⚠ Common exam trap
Watch out — candidates often confuse Azure Logic Apps (a workflow/API integration tool) with Azure Data Factory (a dedicated ETL service), because both use connectors and can automate tasks, but only ADF is purpose-built for large-scale data extraction and loading into data stores.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Azure Data Factory
Azure Data Factory (ADF) is the correct answer because it is a cloud-based ETL (Extract, Transform, Load) and data integration service specifically designed to ingest data from a wide variety of sources—including SaaS applications like Salesforce and ServiceNow—and load it into Azure data stores such as Azure SQL Database, Azure Data Lake Storage, or Azure Synapse Analytics. ADF provides built-in connectors for these SaaS platforms, enabling automated, scheduled, or event-triggered data movement without requiring custom code.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Azure Logic Apps
Why it's wrong here
Azure Logic Apps is a low-code workflow orchestration service designed to automate business processes and integrate applications through triggers and actions connecting to SaaS and on-premises systems. However, it is not a purpose-built ETL tool: it lacks the native data transformation, large-scale copy activity, and pipeline-based scheduling that Azure Data Factory offers. While Logic Apps can handle simple data movement, Azure Data Factory is the proper service for extracting data from SaaS sources and loading it into Azure data stores.
- ✓
Azure Data Factory
Why this is correct
Azure Data Factory is the correct choice because it is a cloud-based ETL and data integration service with over 90 built-in connectors, including dedicated connectors for SaaS applications such as Salesforce and ServiceNow. It lets you build pipelines with copy activities, data flows, and triggers to extract data on a schedule, transform it, and load it into destinations like Azure Synapse Analytics, Azure SQL Database, or Azure Blob Storage. This makes Data Factory the dedicated solution for scheduled, large-scale data movement, unlike workflow, messaging, or event routing alternatives.
- ✗
Azure Event Grid subscriptions
Why it's wrong here
Azure Event Grid is an event routing service that pushes real-time events from publisher sources to subscriber handlers, enabling reactive, event-driven architectures. It is not designed for poll-based, scheduled batch extraction of data from SaaS platforms; its lifecycle centers on near-real-time event delivery rather than ETL pipelines. Azure Data Factory provides the scheduled orchestration and data movement capabilities required for copying data from SaaS sources into analytical stores.
- ✗
Azure Service Bus
Why it's wrong here
Azure Service Bus is a fully managed enterprise message broker that decouples applications by reliably delivering messages through queues and pub/sub topics. It does not extract data from SaaS applications or load it into Azure data warehouses; its role is to relay messages between components at runtime. Azure Data Factory, in contrast, uses its extensive connector library to perform scheduled, at-scale ingestion and transformation from platforms like Salesforce and ServiceNow.
Go deeper
Related to this question
Learn chapter
Azure Regions and Geographies
Key term
Azure Data Factory
Azure Data Factory is a cloud-based data integration service that lets you create, schedule, and orchestrate data pipelines to move and transform data from various sources to destinations.
Key term
SaaS
Software as a Service (SaaS) is a cloud computing model where you use software over the internet without installing it on your own computer.
About these practice questions
One of 981 original AZ-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This AZ-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the AZ-900 exam.