DA0-001 Question #104: Real Exam Question with Answer & Explanation

The correct answer is A: Snowflake.. {"question_number": 7, "correct_answer": "A", "explanation": "The two most common schemas used in data warehouses are the Star Schema and the Snowflake Schema. The Snowflake Schema is an extension of the Star Schema where dimension tables are normalized into multiple related tabl

Data Concepts and Environments

Question

Which one of the following is a common data warehouse schema?

Options

ASnowflake.
BSquare.
CSpiral.
DSphere.

Explanation

{"question_number": 7, "correct_answer": "A", "explanation": "The two most common schemas used in data warehouses are the Star Schema and the Snowflake Schema. The Snowflake Schema is an extension of the Star Schema where dimension tables are normalized into multiple related tables, resembling the shape of a snowflake. Options B (Square), C (Spiral), and D (Sphere) are not real data warehouse schemas - they are distractors. Understanding these schemas is foundational to data warehousing and dimensional modeling.", "generated_by": "claude-sonnet", "llm_judge_score": 4}

Topics

#Data Warehouse#Schema#Snowflake Schema#Data Modeling

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice Browse All DA0-001 Questions