Courseiva
Develop data processing →easyMultiple Select

DP-203 Develop data processing Practice Question

Which TWO of the following are supported sources for Azure Data Factory Copy activity? (Choose two.)

⚠ Common exam trap

Many exam-takers confuse Azure Analysis Services (a semantic model) with Azure SQL Database or Azure Synapse, which are valid sources, leading them to incorrectly select it as a supported source for Copy activity.

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

✓

Amazon S3

Amazon S3 is correct (C) because Azure Data Factory provides a native Amazon S3 connector that the Copy activity can use as a source, reading objects via the S3 API with linked-service credentials. Azure Blob Storage is correct (D) because it is one of ADF's core supported stores, and the Copy activity can read blobs through the Azure Blob Storage connector. Power BI Dataset (A) is not a Copy activity source; ADF interacts with Power BI only for certain dataset-based scenarios, not as a copy source. Azure DevOps (B) is not a data store connector for Copy activity sources. Azure Analysis Services (E) is an analytical model, not a supported Copy activity source store.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✗

    Power BI Dataset

    Why it's wrong here

    Power BI datasets are not supported as sources for Copy activity.

  • ✗

    Azure DevOps

    Why it's wrong here

    Azure DevOps (boards, repos) is not a data store.

  • ✓

    Amazon S3

    Why this is correct

    Amazon S3 is supported via the Amazon S3 connector.

  • ✓

    Azure Blob Storage

    Why this is correct

    Azure Blob Storage is a first-class source for Copy activity.

  • ✗

    Azure Analysis Services

    Why it's wrong here

    Azure Analysis Services is a semantic modelling and tabular query engine, not a data store that Azure Data Factory can read from or write to as a Copy activity source or sink; supported sources include Azure SQL Database, Blob Storage, and SAP HANA via the appropriate connectors. It is tempting because Analysis Services holds business data and appears in the same Azure data platform, but it exposes tabular models over XMLA rather than a copyable dataset endpoint.

Quick reference

AWS S3 Storage Class Comparison

Storage ClassMin DurationRetrievalUse Case
S3 StandardNoneImmediateFrequently accessed data
S3 Standard-IA30 daysImmediateInfrequent access, rapid retrieval
S3 One Zone-IA30 daysImmediateNon-critical infrequent data
S3 Intelligent-TieringNoneImmediate–hoursUnknown or changing access patterns
S3 Glacier Instant90 daysMillisecondsArchive with instant retrieval
S3 Glacier Flexible90 daysMinutes–hoursArchive, flexible retrieval
S3 Glacier Deep Archive180 daysHoursLong-term compliance archive

About these practice questions

One of 509 original DP-203 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 DP-203 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 DP-203 exam.