Question 1

Your company is building an enterprise data platform. You need an orchestration tool to move data from 50 different on-premises and cloud sources into Azure Data Lake Storage Gen2.

The data engineering team requires a visual, code-free interface to build ETL pipelines. They also need to execute SQL queries directly against the files in the Data Lake without provisioning dedicated database compute resources.

Which service should you recommend?

Accepted Answer

Identify the service that combines visual ETL (like Data Factory) with Serverless SQL capabilities.

Question 2

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

Accepted Answer

Choosing Azure Data Factory. While ADF does the ETL part perfectly, it lacks the Serverless SQL engine required by the second half of the prompt.

How to approach this question

Full Answer

Common mistakes

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

More questions from this exam