Question 1

Your company is designing an ELT (Extract, Load, Transform) pipeline.

The pipeline must extract data from 50 different on-premises and cloud data sources, load the raw data into Azure Data Lake Storage Gen2, and then perform complex transformations using Apache Spark. The data engineering team prefers writing transformation logic in Python and Scala notebooks.

Which TWO Azure services should you combine to build this solution? (Select TWO)

Accepted Answer

Identify the orchestrator/extractor (Data Factory) and the Spark-based transformation engine (Databricks).

Question 2

What mistakes do candidates make on this AZ-305 question?

Accepted Answer

Trying to use Stream Analytics for batch processing, or assuming Data Factory can do complex Python/Scala transformations natively without a compute engine like Databricks or Synapse Spark.

How to approach this question

Full Answer

Common mistakes

Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 1

More questions from this exam