az-305 Practice Question 1964
Exam: az-305
Domain: Design data storage solutions
Topic: Design data integration
Difficulty: medium
Your client needs a data integration solution that can handle large volumes of semi-structured data from various sources and perform complex transformations before loading it into an Azure SQL Database. Which of the following architectures should you recommend for this scenario?
Answer Options
A
Use Azure Data Factory for batch processing and ETL jobs.
B
Use Event Grid for real-time event processing and triggering transformations.
C
Use Azure Synapse Pipelines for handling large volumes of semi-structured data and complex transformations.
D
Use a combination of Azure Data Factory and Event Grid for handling semi-structured data.
Correct Answer
C: Use Azure Synapse Pipelines for handling large volumes of semi-structured data and complex transformations.
Explanation
Azure Synapse Pipelines are ideal for handling large volumes of semi-structured data and performing complex transformations due to their advanced data processing capabilities. Azure Data Factory is better suited for batch processing and ETL jobs, while Event Grid is used for real-time event processing. Therefore, Azure Synapse Pipelines are the best fit for this scenario.