DP-900 Describe an analytics workload on Azure Practice Question
Your data engineering team is designing a data pipeline that ingests data from multiple sources into Azure Data Lake Storage Gen2. The data must be cataloged in Azure Purview for discoverability. Which approach ensures that the data lineage is automatically captured?
⚠ Common exam trap
Test-takers frequently confuse data cataloging (scanning) with lineage capture, assuming that scanning the data lake after ingestion (Option D) will automatically show how data got there, but scanning only reveals schema and classification, not the data flow path.
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
✓
Use Azure Data Factory with Purview integration enabled to copy data.
Azure Data Factory's native Purview integration automatically captures lineage metadata during data copy activities. When enabled, Data Factory pushes runtime lineage information (source, sink, transformation steps) directly to Purview without manual intervention, ensuring complete and accurate data provenance.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use Azure Data Factory to copy data and manually register the datasets in Purview.
Why it's wrong here
Manually registering datasets in Purview after an Azure Data Factory copy records only the existence and schema of the data assets; it does not create the implicit source-to-destination relationship that the copy activity establishes at runtime. Because the registration is decoupled from the actual data movement, Purview cannot derive column-level lineage or understand which pipeline produced a specific output, so lineage remains incomplete. This option lacks the automatic instrumentation that the native ADF–Purview integration provides, making it a fragmented approach for lineage tracking.
- ✓
Use Azure Data Factory with Purview integration enabled to copy data.
Why this is correct
Enabling Purview integration on Azure Data Factory causes every executed copy activity to automatically emit lineage metadata to Purview, including the source and sink datasets and the column-level mappings defined in the activity. This is a first-class, out-of-the-box integration that captures lineage as part of the pipeline run rather than as a separate manual step. The result is reliable, up-to-date lineage without custom code, which is exactly what the data engineering team needs.
- ✗
Use Azure Databricks to write data and call Purview's Atlas API to update lineage.
Why it's wrong here
Calling Purview's Atlas API from an Azure Databricks job is a programmatic, low-level approach that requires custom code to construct lineage entities, relationships, and status updates for every write operation. Purview does not automatically intercept Databricks transformations or write operations unless you build and maintain that instrumentation yourself, and even then, the Atlas API is an internal-facing interface intended for custom lineage solutions rather than routine pipeline telemetry. This option introduces significant development overhead and fragility compared to the native integration, making it a poorer fit for a designed pipeline.
- ✗
Schedule Purview scans on the data lake after data ingestion.
Why it's wrong here
Scheduling Purview scans on the data lake after ingestion captures metadata such as schema, classifications, and glossary terms at rest, but scans cannot see the data movement path from source to destination. Lineage is about how data is transformed and moved between processes, which requires integration with the orchestration engine (e.g., ADF activity-level metadata) to reconstruct the relationship. A scan provides a point-in-time snapshot of data assets, not a causal chain between them, so it cannot satisfy the automatic lineage capture requirement.
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Data lake
A data lake is a centralized storage repository that holds vast amounts of raw data in its native format until it is needed for analysis.
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.
About these practice questions
One of 820 original DP-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 DP-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 DP-900 exam.