Microsoft Azure Data Engineer Associate - DP-203
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
You are tasked with designing a solution to ingest and transform data from multiple sources into an Azure Synapse Analytics workspace. The data sources include relational databases, NoSQL databases, and file storage systems. Which of the following Azure services and techniques would you use to achieve this, and how would you design the solution to handle the different data source types?
Explanation:
Option B is the most suitable approach for ingesting and transforming data from multiple sources into an Azure Synapse Analytics workspace. By using Azure Data Factory, you can leverage separate Copy Data activities for each data source type, ensuring efficient data ingestion. Then, by using Azure Data Flow activities, you can perform the necessary transformations on the data, regardless of the source type. This approach allows for flexible and efficient data processing and seamless integration with the Synapse Analytics workspace.