nerdexam
Microsoft

AI-102 · Question #154

Drag and Drop Question Match the Azure services to the appropriate locations in the architecture. To answer, drag the appropriate service from the column on the left to its location on the right…

The correct answer is Azure SQL Database; Azure Data Factory; Azure Synapse Analytics; Azure Stream Analytics; Azure Synapse Analytics. The correct arrangement maps each architecture position to the most appropriate Azure service: Azure SQL Database serves as the operational/transactional source data store, Azure Data Factory orchestrates and moves/transforms data through the pipeline (ETL/ELT), Azure Synapse…

Submitted by miguelv· Mar 30, 2026Design and Implement Data Storage and Processing Solutions / Describe core Azure data services and their roles in a data analytics architecture (DP-900 / DP-203 aligned)

Question

Drag and Drop Question Match the Azure services to the appropriate locations in the architecture. To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Answer:

Exhibit

AI-102 question #154 exhibit

Answer Area

Drag items

Azure Data CatalogAzure Data FactoryAzure Synapse AnalyticsAzure SQL DatabaseAzure Stream Analytics

Correct arrangement

  • Azure SQL Database
  • Azure Data Factory
  • Azure Synapse Analytics
  • Azure Stream Analytics
  • Azure Synapse Analytics

Explanation

The correct arrangement maps each architecture position to the most appropriate Azure service: Azure SQL Database serves as the operational/transactional source data store, Azure Data Factory orchestrates and moves/transforms data through the pipeline (ETL/ELT), Azure Synapse Analytics acts as the enterprise analytics and data warehousing engine (appearing twice, reflecting its dual role in ingestion/transformation and serving analytical queries), and Azure Stream Analytics handles real-time streaming data processing. This architecture represents a classic modern data warehouse pattern where operational data is extracted, streamed, and analyzed at scale. Azure Data Catalog is a metadata/governance service not used in the data movement pipeline itself, making it incorrect for any of these positions.

Topics

#Modern Data Warehouse#Azure Data Architecture#Data Integration#Real-Time Analytics

Community Discussion

No community discussion yet for this question.

Full AI-102 Practice