Question 1

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

Requirements:
1. Extract data from 50 different on-premises and cloud data sources (SQL, Oracle, Salesforce, REST APIs).
2. Orchestrate the movement of this data into Azure Data Lake Storage Gen2.
3. Perform complex data transformations using Apache Spark and Python.
4. The transformation code must be developed collaboratively by data engineers using interactive notebooks.

Which TWO Azure services should you combine to meet these requirements? (Select TWO)

Accepted Answer

Identify the orchestration/extraction tool (Data Factory) and the Spark/Notebook transformation tool (Databricks).

Question 2

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

Accepted Answer

Trying to use a single service for everything. While Synapse Analytics could potentially do both, the specific combination of '90+ connectors' and 'collaborative Python notebooks' strongly points to the classic ADF + Databricks pattern.

How to approach this question

Full Answer

Common mistakes

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

More questions from this exam