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 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?
A
Use Azure Data Factory with a single Copy Data activity to handle all data sources and store the data in Azure Blob Storage. Then, use Azure Synapse Pipelines to load the data into the Synapse Analytics workspace.
B
Use Azure Data Factory with separate Copy Data activities for each data source type, and then use Azure Data Flow activities to transform the data before loading it into the Synapse Analytics workspace.
C
Use Azure Data Lake Storage Gen2 to store the data from all sources, and then use Azure Databricks to run custom scripts for data transformation and loading into the Synapse Analytics workspace.
D
Use Azure Stream Analytics to ingest the data from all sources as a stream, and then use Azure Functions to process the data and store it in the Synapse Analytics workspace.