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 various sources into an Azure Data Lake Storage Gen2. The data sources include relational databases, CSV files, and JSON documents. Which of the following Azure services would you use to achieve this, and how would you design the solution to handle the different data formats?
Explanation:
Option C is the most suitable approach. Azure Data Factory provides a comprehensive solution for ingesting and transforming data from various sources. By using a combination of Copy Data and Data Flow activities, you can handle different data formats and perform the necessary transformations. Copy Data activities can be used to ingest data from relational databases, CSV files, and JSON documents, while Data Flow activities can be used to cleanse, transform, and merge the data before storing it in the Data Lake Storage Gen2.