DA0-002 Data Concepts and Environments Practice Question
A data engineer is designing a database for an online store. The database must enforce strict consistency and handle complex transactions involving multiple tables, such as orders, customers, and inventory. Which database type should the engineer choose?
⚠ Common exam trap
The trap here is assuming that any database that can store data is suitable; however, only relational databases provide the strict consistency and multi-table transaction support required for this scenario.
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
✓
Relational database
The correct answer is Relational database because it provides ACID compliance and supports complex joins, which are essential for handling transactions across multiple related tables. Other database types lack the necessary transactional guarantees or relational capabilities for this use case.
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 this is correct
Relational databases use ACID transactions, ensuring strict consistency and supporting complex joins across normalized tables. They are ideal for transactional systems like order processing where data integrity is critical. This makes relational the best fit for the scenario.
- ✗
Graph database
Why it's wrong here
Graph databases excel at modeling relationships and traversing connected data, such as social networks. However, they are not optimized for high-volume transactional processing with strict consistency across many tables. They would not efficiently handle the order processing workload described.
- ✗
Key-value store
Why it's wrong here
Key-value stores provide fast lookups but lack support for complex transactions and relationships between entities. They cannot enforce foreign key constraints or perform multi-table joins, which are required for order processing. Thus, they are unsuitable for this scenario.
- ✗
Document database
Why it's wrong here
Document databases store semi-structured data and offer flexibility but typically do not enforce strict consistency across multiple documents. They are better for content management or catalogs, not for complex transactional integrity. Therefore, they fail to meet the strict consistency requirement.
Go deeper
Related to this question
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 →
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.