ExpertMedium1 markMultiple Choice
AZ-305 · Question 20 · Domain 2.2: Data Integration
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?
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?
Answer options:
A.
Azure Data Factory
B.
Azure Synapse Analytics
C.
Azure Databricks
D.
Azure Stream Analytics
How to approach this question
Identify the service that combines visual ETL (like Data Factory) with Serverless SQL capabilities.
Full Answer
B.Azure Synapse Analytics✓ Correct
Azure Synapse Analytics is an integrated analytics service. It includes Synapse Pipelines, which use the exact same visual, code-free integration engine as Azure Data Factory. Crucially, Synapse also includes Serverless SQL pools. This feature allows users to run T-SQL queries directly against CSV, Parquet, or JSON files stored in Azure Data Lake Storage Gen2 without having to provision or manage dedicated SQL compute clusters.
Common mistakes
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.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 5
55 questions · hints · full answers · grading
More questions from this exam
Q01Contoso Ltd has 50 subscriptions across 3 business units. Each business unit manages its own IT o...EasyQ02You are designing a monitoring solution for a hybrid environment. The environment consists of 200...MediumQ03Your company uses Microsoft Sentinel integrated with a Log Analytics workspace. The workspace ing...HardQ04You are designing an application monitoring strategy using Application Insights. The application ...MediumQ05A highly regulated financial institution is migrating to Microsoft 365 and Azure. They currently ...Hard