ExpertHard1 markMultiple Choice
AZ-305 · Question 21 · Domain 2.2: Data Integration
Your company is building a modern data warehouse. You need to ingest 5 TB of raw JSON data daily from an external REST API, perform complex machine learning transformations on the data, and load the cleansed data into an Azure Synapse Analytics dedicated SQL pool.
The data engineering team prefers writing transformations in Python and Scala. The orchestration team prefers a visual, drag-and-drop interface for scheduling and monitoring the end-to-end pipeline.
Which TWO services should you combine to meet these requirements? (Select TWO)
Your company is building a modern data warehouse. You need to ingest 5 TB of raw JSON data daily from an external REST API, perform complex machine learning transformations on the data, and load the cleansed data into an Azure Synapse Analytics dedicated SQL pool.
The data engineering team prefers writing transformations in Python and Scala. The orchestration team prefers a visual, drag-and-drop interface for scheduling and monitoring the end-to-end pipeline.
Which TWO services should you combine to meet these requirements? (Select TWO)
Answer options:
A.
Azure Data Factory
B.
Azure Databricks
C.
Azure Stream Analytics
D.
Azure Logic Apps
E.
Azure Functions
How to approach this question
Identify the service for visual orchestration (ADF) and the service for big data Python/Scala transformations (Databricks).
Full Answer
This is a classic modern data warehouse pattern. Azure Data Factory (ADF) is used as the orchestrator because it provides a visual, drag-and-drop interface for scheduling, monitoring, and moving data (Copy Activity). For the complex transformations requiring Python and Scala, ADF can trigger an Azure Databricks notebook activity. Databricks provides a highly optimized Apache Spark environment perfect for big data machine learning transformations.
Common mistakes
Trying to use Data Factory Mapping Data Flows for the transformations. While visual, it doesn't meet the requirement of the engineering team wanting to write Python/Scala code.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 2
55 questions · hints · full answers · grading
More questions from this exam
Q01Fabrikam Inc. is a global financial services company with 200 Azure subscriptions managed via a c...HardQ02A healthcare organization has 500 on-premises Windows Server VMs and 300 Azure VMs. They are impl...HardQ03You are designing a security monitoring solution using Microsoft Sentinel.
The compliance depar...EasyQ04Your company has a microservices application deployed across multiple Azure App Service instances...MediumQ05A defense contractor is migrating to Microsoft 365 and Azure. They have a strict security policy ...Hard