Microsoft Azure Data Engineer Associate - DP-203
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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.