Question 1

A retail company needs to orchestrate data movement from 20 different on-premises SQL Server databases into Azure Data Lake Storage Gen2. The data must be transformed using serverless Apache Spark pools before being loaded into a dedicated SQL pool for reporting. You want to use a single unified workspace to manage the pipelines, Spark pools, and SQL pools. Which service should you recommend?

Accepted Answer

Identify the service that combines data integration, enterprise data warehousing, and big data analytics.

Question 2

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

Accepted Answer

Choosing Azure Data Factory, which would require managing multiple separate services.

How to approach this question

Full Answer

Common mistakes

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

More questions from this exam