DP-203 · Question #414
You have an Azure subscription that contains an Azure Synapse Analytics account and a Microsoft Purview account. You create a pipeline named Pipeline1 for data ingestion to a dedicated SQL pool. You…
The correct answer is B. Copy D. Data flow. Only specific Azure Synapse pipeline activities report data lineage metadata to Microsoft Purview. Copy and Data flow activities are the two supported activities that automatically push lineage information.
Question
You have an Azure subscription that contains an Azure Synapse Analytics account and a Microsoft Purview account. You create a pipeline named Pipeline1 for data ingestion to a dedicated SQL pool. You need to generate data lineage from Pipeline1 to Microsoft Purview. Which two activities generate data lineage? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Options
- AWeb
- BCopy
- CWebHook
- DData flow
- EValidation
How the community answered
(30 responses)- A13% (4)
- B77% (23)
- C3% (1)
- E7% (2)
Why each option
Only specific Azure Synapse pipeline activities report data lineage metadata to Microsoft Purview. Copy and Data flow activities are the two supported activities that automatically push lineage information.
The Web activity makes HTTP calls to external endpoints and does not interact with data assets in a way that Purview can capture as lineage.
The Copy activity reports source-to-destination data movement lineage to Microsoft Purview, capturing which datasets were read and written during pipeline execution.
The WebHook activity waits for an external callback and does not involve data movement or transformation that would generate lineage metadata.
The Data flow activity reports transformation lineage to Microsoft Purview, including the input datasets, transformations applied, and output datasets, enabling end-to-end lineage visualization.
The Validation activity checks whether a dataset meets specified conditions but does not read or write data in a way that produces lineage information.
Concept tested: Azure Synapse and Microsoft Purview data lineage integration
Source: https://learn.microsoft.com/en-us/azure/synapse-analytics/catalog-and-governance/quickstart-connect-azure-purview
Topics
Community Discussion
No community discussion yet for this question.