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 designing an Azure Data Factory pipeline to ingest and transform data from an Azure Event Hub to Azure SQL Database. The data includes real-time sensor readings that need to be aggregated by device type and time window. Which activities and connectors would you use in the pipeline to achieve this, and how would you configure the pipeline to handle the real-time data processing?
A
Use a Copy Data activity to copy the data from Event Hub to SQL Database without any aggregation.
B
Use a Data Flow activity to read the data from Event Hub, aggregate it by device type and time window, and then write the aggregated data to SQL Database.
C
Use a Lookup activity to retrieve the device types, followed by a ForEach activity to iterate over the types and a Copy Data activity to copy the aggregated data to SQL Database.
D
Use a Web activity to trigger an external script that aggregates the data before copying it to SQL Database.