Courseiva
Design and implement data storageeasyMultiple ChoiceObjective-mapped

Azure Data Lake Storage Gen2 for Analytics — Choosing the Primary Storage Layer

You are designing a data lake for a manufacturing company that will store sensor readings in Parquet format. The data will be used by data scientists for batch training and by analysts for ad-hoc queries. Which Azure service should you use as the primary storage layer?

Quick Answer

ADLS Gen2 is the right fit here because it is built specifically to serve as a shared, general-purpose analytics store that multiple types of consumers can hit at once without stepping on each other. Underneath, it is still Azure Blob Storage, so it inherits massive scalability and low-cost object storage, but the added hierarchical namespace organizes that storage into real directories, which both improves performance for engines reading large numbers of Parquet files and enables POSIX-style access control lists at the folder level. That combination matters directly for this scenario: data scientists running batch training jobs typically need high-throughput, parallel reads across large volumes of files, the kind of access pattern Spark or similar engines rely on, while analysts running ad-hoc queries need to be able to reach specific datasets without being granted access to everything in the account. A flat, non-hierarchical store would struggle to offer that same directory-level security boundary. Recognize this pattern in future questions: whenever a scenario describes a single storage layer that needs to serve both large-scale batch analytics workloads and more selective, permission-sensitive ad-hoc access, especially with structured file formats like Parquet, ADLS Gen2 is the service designed to satisfy both needs simultaneously, rather than requiring separate storage systems for each audience.

⚠ Common exam trap

It's easy for candidates to confuse a compute service (Synapse SQL Pool) with a storage service, or assuming that Blob Storage alone is sufficient without considering the hierarchical namespace required for data lake operations.

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

Azure Data Lake Storage Gen2 (ADLS Gen2) is the correct primary storage layer because it combines a hierarchical namespace with Azure Blob Storage's scalable object storage, providing POSIX-compliant access control and directory-level operations. This makes it ideal for storing Parquet files used by data scientists for batch training (via Spark or PolyBase) and by analysts for ad-hoc queries (via Synapse SQL or Azure Databricks), as it supports both high-throughput analytics and fine-grained security.

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

    Why this is correct

    ADLS Gen2 provides hierarchical namespace and is optimized for analytics workloads.

  • Azure Synapse SQL Pool

    Why it's wrong here

    Synapse SQL Pool is a compute service for querying, not a storage layer.

  • Azure Blob Storage

    Why it's wrong here

    Blob Storage lacks hierarchical namespace, which is needed for data lake operations.

  • Azure SQL Database

    Why it's wrong here

    Azure SQL is a relational database, not suitable for storing Parquet files at scale.

Quick reference

Azure Blob Storage Tier Comparison

TierStorage CostRetrieval CostLatencyUse Case
HotHighestLowestImmediateActive data, frequent reads
CoolLowerHigherImmediateData accessed < once / month
ColdLower stillHigherImmediateData accessed < once / quarter
ArchiveLowestHighest + rehydration delayHoursLong-term compliance retention

Go deeper

Related to this question

About these practice questions

Courseiva writes every DP-203 question from scratch — 760 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Same concept, more angles

2 more ways this is tested on DP-203

These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.

Variation 1. You are designing a data storage solution for a retail company that needs to store semi-structured IoT sensor data from thousands of devices. The data is ingested in near real-time, and queries will involve filtering by device ID and timestamp. The solution must minimize storage costs while supporting interactive queries. Which TWO Azure data storage options are most appropriate?

easy
  • A.Azure Table Storage
  • B.Azure Cosmos DB
  • C.Azure Blob Storage
  • D.Azure Data Lake Storage Gen2
  • E.Azure SQL Database

Why C: Azure Blob Storage (C) is correct because it provides a cost-effective, scalable object store for semi-structured IoT data, supporting near real-time ingestion via REST APIs or SDKs and enabling interactive queries through Azure Data Lake Storage Gen2's hierarchical namespace and integration with query engines like Azure Synapse Serverless SQL or PolyBase. Azure Data Lake Storage Gen2 (D) is correct as it builds on Blob Storage with a hierarchical namespace, optimized for analytics workloads and interactive queries using tools like Azure Synapse or Databricks, while minimizing costs through tiered storage and lifecycle management.

Variation 2. You are designing a data storage solution for a retail company that needs to store semi-structured JSON data from IoT sensors. The data is ingested continuously and must support both real-time analytics and batch processing. Which Azure data store should you recommend?

medium
  • A.Azure Data Lake Storage Gen2
  • B.Azure Blob Storage
  • C.Azure SQL Database
  • D.Azure Cosmos DB

Why A: Azure Data Lake Storage Gen2 (ADLS Gen2) is the correct choice because it combines a hierarchical file system with the scalability and low cost of Azure Blob Storage, making it ideal for storing semi-structured JSON data from IoT sensors. It supports both real-time analytics (via services like Azure Stream Analytics or Apache Spark) and batch processing (via tools like Azure Data Factory or PolyBase) without data movement, and it natively handles JSON files with schema-on-read capabilities.

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.