Courseiva

DA0-002 Data Concepts and Environments Practice Question

A logistics company uses a key-value store to cache real-time shipment tracking updates. The data model has no fixed schema, and each shipment record may contain different attributes. Which data storage approach is being used?

⚠ Common exam trap

The trap here is equating any schema-less storage with a data lake, when the key-based, low-latency access pattern points specifically to a key-value store.

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

✓

NoSQL key-value store

The scenario describes storing shipment records under unique identifiers with varying attributes and no fixed schema, which is the defining characteristic of a key-value store. Key-value stores excel at fast, simple lookups by key, making them ideal for caching real-time tracking updates. Relational databases, warehouses, and lakes impose structure or latency that conflict with these requirements.

Answer analysis

Option-by-option breakdown

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

  • ✗

    Relational database

    Why it's wrong here

    A relational database enforces a predefined schema with tables, columns, and data types. The scenario explicitly states there is no fixed schema and records vary in attributes, which contradicts the rigid structure of a relational model. Using a relational database would require schema migrations each time a new attribute appears, defeating the flexibility the company needs.

  • ✗

    Data warehouse

    Why it's wrong here

    A data warehouse is optimized for analytical queries over structured, integrated data loaded through ETL processes. It typically requires a defined schema and is not designed for low-latency key-based lookups of individual shipment records. Using a warehouse for real-time caching would introduce unnecessary latency and structural rigidity.

  • ✗

    Data lake

    Why it's wrong here

    A data lake stores raw data in various formats for later analysis, but it does not provide the low-latency key-based retrieval characteristic of a cache. The scenario emphasizes real-time shipment tracking updates, which require fast lookups by key. A data lake is better suited for batch analytics and long-term storage than for serving live tracking queries.

  • ✓

    NoSQL key-value store

    Why this is correct

    A key-value store maps unique keys to arbitrary values without requiring a fixed schema. Each shipment record can be stored under its shipment ID as the key, and the value can contain any set of attributes. This matches the description of schema-less, flexible storage for real-time caching of tracking updates.

About these practice questions

Courseiva writes every DA0-002 question from scratch — 1,004 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

JA

Written and reviewed by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

Last reviewed September 2026 · checked against the official CompTIA exam blueprint

This DA0-002 practice question is part of Courseiva's free CompTIA 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 DA0-002 exam.