Courseiva
Describe Azure architecture and servicesmediumMultiple ChoiceObjective-mapped

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.

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 →

How Courseiva writes practice questions · Editorial policy

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.