nerdexam
MicrosoftMicrosoft

AI-102 · Question #154

AI-102 Question #154: Real Exam Question with Answer & 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 Ana

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:

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 PracticeBrowse All AI-102 Questions