Answer-first summary for fast verification
Answer: Use Azure Data Factory with a combination of Copy Data and Data Flow activities to handle the different data formats and perform transformations.
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.
Author: LeetQuiz Editorial Team
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?
A
Use Azure Data Factory with a single Copy Data activity to handle all data sources and formats.
B
Use Azure Data Factory with separate Copy Data activities for each data source and format, and then merge the data in the destination.
C
Use Azure Data Factory with a combination of Copy Data and Data Flow activities to handle the different data formats and perform transformations.
D
Use Azure Stream Analytics to ingest the data and perform real-time transformations before storing it in the Data Lake Storage Gen2.
No comments yet.