DA0-002 Data Analysis Practice Question
A data analyst is designing a data model for a sales data warehouse. The model should optimize query performance for aggregations by minimizing joins and duplicating data where necessary. Which schema design should the analyst use?
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
Star schema denormalizes dimensions into a single table, reducing joins and improving query speed for aggregates. Snowflake schema normalizes dimensions increasing joins. Entity-relationship and 3NF are optimized for transactional systems, not analytical queries.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Entity-relationship model
Why it's wrong here
Entity-relationship model is used for transactional systems, not for data warehousing.
- ✗
Snowflake schema
Why it's wrong here
Snowflake schema normalizes dimensions, increasing joins and potentially reducing query performance.
- ✗
3NF normalized model
Why it's wrong here
3NF is for transactional systems and is overly normalized for analytical queries.
- ✓
Star schema
Why this is correct
Star schema denormalizes dimensions, minimizing joins and optimizing aggregate queries.
Go deeper
Related to this question
About these practice questions
This DA0-002 question is part of Courseiva's 986-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.