DA0-002 Data Concepts and Environments Practice Question
A financial application requires fast query performance for aggregations on large historical datasets. The schema has many lookup tables. Which schema design is most efficient for this workload?
⚠ Common exam trap
It's easy for candidates to confuse normalization with performance, assuming snowflake or 3NF schemas are faster due to reduced redundancy, when in fact denormalization in a star schema minimizes joins for analytical queries.
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
✓
Star schema
The star schema is most efficient for this workload because it denormalizes lookup tables into dimension tables, reducing the number of joins required for aggregations. This design optimizes query performance for large historical datasets by enabling faster full table scans and simpler query plans, which is critical for financial applications needing rapid aggregations.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Snowflake schema
Why it's wrong here
Snowflake schema normalizes dimension tables, increasing joins and potentially slowing query performance.
- ✓
Star schema
Why this is correct
Star schema denormalizes dimension tables, reducing the number of joins and improving query performance for aggregations.
- ✗
Wide table
Why it's wrong here
A wide table can reduce joins but may cause data redundancy and update anomalies, and is not a standard design pattern.
- ✗
Third normal form (3NF)
Why it's wrong here
3NF is highly normalized, which reduces data redundancy but increases join complexity, not ideal for fast aggregations.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DA0-002 question from scratch — 986 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 by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.