Microsoft Azure Data Engineer Associate - DP-203
Get started today
Ultimate access to all questions.
You are designing an Azure Data Factory pipeline to ingest and transform data from an Azure Blob Storage container to Azure SQL Database. The data includes a large CSV file that needs to be split into smaller files based on a specific column, 'Region'. Which activities and connectors would you use in the pipeline to achieve this, and how would you configure the pipeline to handle the splitting and transformation?
You are designing an Azure Data Factory pipeline to ingest and transform data from an Azure Blob Storage container to Azure SQL Database. The data includes a large CSV file that needs to be split into smaller files based on a specific column, 'Region'. Which activities and connectors would you use in the pipeline to achieve this, and how would you configure the pipeline to handle the splitting and transformation?
Simulated