What is the best recommendation to achieve the goal?

Your company has a data team of Transact-SQL experts.

You plan to ingest data from multiple sources into Azure Event Hubs.

You need to recommend which technology the data team should use to move and query data from Event Hubs to Azure Storage. The solution must leverage the data team’s existing skills.

What is the best recommendation to achieve the goal? More than one answer choice may achieve the goal.
A . Azure Notification Hubs
B . Azure Event Grid
C . Apache Kafka streams
D . Azure Stream Analytics

View Answer

Answer: B

Explanation:

Event Hubs Capture is the easiest way to automatically deliver streamed data in Event Hubs to an Azure Blob storage or Azure Data Lake store. You can subsequently process and deliver the data to any other storage destinations of your choice, such as SQL Data Warehouse or Cosmos DB. You to capture data from your event hub into a SQL data warehouse by using an Azure function triggered by an event grid.

First, you create an event hub with the Capture feature enabled and set an Azure blob storage as the destination. Data generated by WindTurbineGenerator is streamed into the event hub and is automatically captured into Azure Storage as Avro files. Next, you create an Azure Event Grid subscription with the Event Hubs namespace as its source and the Azure Function endpoint as its destination. Whenever a new Avro file is delivered to the Azure Storage blob by the Event Hubs Capture feature, Event Grid notifies the Azure Function with the blob URI. The Function then migrates data from the blob to a SQL data warehouse.

References:

https://docs.microsoft.com/en-us/azure/event-hubs/store-captured-data-data-warehouse