dp-203 Practice Question 1945
Exam: dp-203
Domain: Design and develop data processing
Topic: Ingest and transform data
Difficulty: medium
You are designing an Azure Data Factory pipeline to ingest data from an on-premises SQL Server database into Azure Blob Storage. The data needs to be transformed before being stored in Blob Storage. Which combination of Azure services should you use to achieve this?
Answer Options
A
Only Azure Data Factory Copy Activity
B
Azure Data Factory Copy Activity and Mapping Data Flows with a self-hosted Integration Runtime
C
Only Mapping Data Flows
D
Azure Data Factory Copy Activity and Mapping Data Flows without a self-hosted Integration Runtime
Correct Answer
B: Azure Data Factory Copy Activity and Mapping Data Flows with a self-hosted Integration Runtime
Explanation
The correct answer is using the Azure Data Factory Copy Activity with a self-hosted Integration Runtime for on-premises data access and then using Mapping Data Flows for transformation. The Copy Activity will handle the ingestion from the on-premises SQL Server to Azure Blob Storage, while Mapping Data Flows can be used for complex transformations. Other options like only using Copy Activity or only using Mapping Data Flows without a self-hosted Integration Runtime would not meet the requirements.