Courseiva
Design and implement data storagemediumMatchingObjective-mapped

DP-203 Design and implement data storage Practice Question

Match each Azure service to its primary purpose in a data engineering pipeline.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Scalable data lake for analytics workloads

Unified analytics platform with SQL and Spark

Cloud-based ETL and data integration service

Real-time stream processing service

Apache Spark-based analytics platform

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

Azure Data Lake Storage Gen2: Scalable data lake for big data analytics.

The correct matches are: Azure Data Lake Storage Gen2 as a scalable data lake, Azure Synapse Analytics as a unified data warehousing platform, Azure Data Factory for data integration and orchestration, and Azure Databricks for Spark-based analytics. Common confusions include swapping storage and integration services, or mistaking data lakes for data warehousing.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Azure Data Lake Storage Gen2: Scalable data lake for big data analytics.

    Why this is correct

    Azure Data Lake Storage Gen2 is designed for massive scale data storage and analytics, providing a hierarchical namespace and POSIX-like access.

  • Azure Synapse Analytics: Unified analytics platform for large-scale data warehousing.

    Why this is correct

    Azure Synapse Analytics integrates data warehousing, big data analytics, and data integration into a single workspace.

  • Azure Data Factory: Cloud data integration service for orchestrating data movement.

    Why this is correct

    Azure Data Factory is a serverless data integration service that allows creating, scheduling, and orchestrating data pipelines.

  • Azure Databricks: Collaborative Apache Spark-based analytics platform.

    Why this is correct

    Azure Databricks provides an interactive workspace for big data processing and machine learning using Apache Spark.

  • Azure Data Lake Storage Gen2: Cloud data integration service for orchestrating data movement.

    Why it's wrong here

    This describes Azure Data Factory, not Azure Data Lake Storage Gen2. Data Lake Storage is a storage service, not an integration service.

  • Azure Synapse Analytics: Scalable data lake for big data analytics.

    Why it's wrong here

    This describes Azure Data Lake Storage Gen2, not Azure Synapse Analytics. Synapse is a data warehousing and analytics platform.

Go deeper

Related to this question

About these practice questions

One of 760 original DP-203 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This DP-203 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-203 exam.