ExpertMedium1 markMultiple Choice
AZ-305 · Question 20 · Domain 2.2: Data Integration
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?
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?
Answer options:
A.
Azure Data Factory.
B.
Azure Synapse Analytics.
C.
Azure Databricks.
D.
Azure HDInsight.
How to approach this question
Identify the service that combines data integration, enterprise data warehousing, and big data analytics.
Full Answer
B.Azure Synapse Analytics.✓ Correct
Azure Synapse Analytics.
Azure Synapse Analytics brings together data integration (pipelines), enterprise data warehousing (dedicated SQL pools), and big data analytics (Spark pools) into a single unified workspace.
Common mistakes
Choosing Azure Data Factory, which would require managing multiple separate services.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 6
55 questions · hints · full answers · grading
More questions from this exam
Q01Contoso Ltd is a global manufacturing company with 50,000 employees. They operate a mix of on-pre...MediumQ02A financial institution has 500 Windows Server VMs on-premises and 200 VMs in Azure. They need to...HardQ03An enterprise uses Azure Sentinel and Log Analytics. They ingest 500 GB of logs daily. The IT bud...HardQ04You are designing a monitoring strategy for a new Azure deployment consisting of App Service, Azu...EasyQ05A healthcare company uses Microsoft Entra ID (Azure AD). They need to implement a security policy...Medium