DA0-002 Data Concepts and Environments Practice Question
A data architect is designing a system to handle a workload that requires strong consistency and complex multi-table joins for financial reporting. Which two characteristics should the architect prioritize when selecting the database technology? (Choose two.)
⚠ Common exam trap
The trap here is assuming that any modern database can handle financial reporting, when the combination of strong consistency and complex joins specifically points to ACID-compliant relational systems.
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
✓
A relational schema with well-defined foreign key relationships
Financial reporting demands strong consistency and the ability to join data across multiple related tables. ACID compliance guarantees that transactions complete reliably without partial updates, and a relational schema with foreign keys enforces the relationships that make complex joins both possible and efficient. Together these characteristics satisfy the core requirements, while eventual consistency, wide-column storage, and document models each sacrifice one or both of these needs.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Denormalized wide-column storage to optimize write throughput
Why it's wrong here
Wide-column stores are optimized for high-volume writes and flexible schemas, but they typically lack the join capabilities and transactional guarantees needed for financial reporting. Denormalization duplicates data and complicates consistency, which contradicts the strong consistency requirement. This approach is better suited to time-series or high-write workloads than to complex analytical joins.
- ✗
A schema-less document model to accommodate evolving report formats
Why it's wrong here
A schema-less document model offers flexibility but provides weak support for multi-table joins and complex relational queries. Financial reporting depends on precise relationships between entities such as accounts, transactions, and ledgers. Choosing a document model would trade away the structural integrity and join performance the architect needs, making it unsuitable for this workload.
- ✓
A relational schema with well-defined foreign key relationships
Why this is correct
A relational schema with foreign keys enforces referential integrity and supports the complex multi-table joins required for financial reporting. Well-defined relationships allow the query optimizer to execute joins efficiently and ensure that related records remain consistent. This characteristic aligns directly with both the strong consistency and complex join requirements in the scenario.
- ✓
ACID compliance to guarantee transaction integrity
Why this is correct
ACID compliance ensures that transactions are atomic, consistent, isolated, and durable, which is essential for financial reporting where partial or inconsistent updates could corrupt results. Complex multi-table joins also benefit from the transactional guarantees that relational systems provide. Prioritizing ACID compliance directly supports the strong consistency requirement stated in the scenario.
- ✗
Eventual consistency to maximize availability during network partitions
Why it's wrong here
Eventual consistency allows replicas to diverge temporarily, which conflicts with the strong consistency requirement for financial reporting. While it improves availability in distributed systems, it can produce stale reads that are unacceptable when aggregating financial data across multiple tables. This characteristic would undermine the accuracy the architect needs.
Go deeper
Related to this question
About these practice questions
One of 1,004 original DA0-002 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 →
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.