az-305 Practice Question 1963
Exam: az-305
Domain: Design data storage solutions
Topic: Design data integration
Difficulty: medium
You are designing a data integration solution that requires real-time processing of events from multiple sources and immediate transformation before storing them in a SQL database. Which of the following architectures would you recommend to achieve this requirement efficiently?
Answer Options
A
Use Azure Data Factory to process and transform events in batches.
B
Use Azure Synapse Pipelines for real-time event processing and transformation.
C
Use Event Grid to trigger real-time processing and transformation using Azure Functions or Logic Apps.
D
Use a combination of Azure Data Factory and Azure Synapse Pipelines for real-time processing.
Correct Answer
C: Use Event Grid to trigger real-time processing and transformation using Azure Functions or Logic Apps.
Explanation
Event Grid is designed for real-time event processing and can trigger Azure Functions or Logic Apps for immediate transformation. Azure Data Factory is more suited for batch processing and complex ETL jobs, while Azure Synapse Pipelines are best for large-scale data warehousing and analytics tasks. Therefore, Event Grid is the most appropriate choice for real-time event processing and transformation.