Bird
0
0

What is the main characteristic of a star schema in a data warehouse?

easy📝 Conceptual Q11 of 15
SQL - Database Design and Normalization
What is the main characteristic of a star schema in a data warehouse?
AOne central fact table connected to multiple dimension tables
BMultiple fact tables connected to one dimension table
COnly dimension tables without any fact tables
DA flat table with no relationships
Step-by-Step Solution
Solution:

  1. Step 1: Understand star schema structure

    A star schema has a central fact table that stores measurable data.

  2. Step 2: Identify dimension tables role

    Dimension tables surround the fact table and provide descriptive attributes.

  3. Final Answer:

    One central fact table connected to multiple dimension tables -> Option A

  4. Quick Check:

    Star schema = central fact + many dimensions [OK]
Quick Trick: Fact table is the center, dimensions are spokes [OK]
Common Mistakes:
  • Confusing fact and dimension tables
  • Thinking star schema has multiple fact tables
  • Assuming no relationships exist

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
Advanced Query Patterns - Running total without window functions - Quiz 10hard Advanced Window Functions - LAG function for previous row access - Quiz 8hard CASE Expressions - Searched CASE syntax - Quiz 2easy Indexes and Query Performance - Composite index and column order - Quiz 2easy Indexes and Query Performance - Index impact on INSERT and UPDATE - Quiz 13medium Stored Procedures and Functions - Function vs procedure decision - Quiz 11easy Transactions and Data Integrity - ACID properties mental model - Quiz 1easy Triggers - AFTER trigger execution - Quiz 3easy Triggers - UPDATE trigger with OLD and NEW - Quiz 3easy Window Functions Fundamentals - Window frame specification (ROWS BETWEEN) - Quiz 13medium