Bird
0
0

Which table in a star schema typically contains numeric measures like sales amount or quantity?

easy📝 Conceptual Q2 of 15
SQL - Database Design and Normalization
Which table in a star schema typically contains numeric measures like sales amount or quantity?
ADimension table
BFact table
CLookup table
DBridge table
Step-by-Step Solution
Solution:

  1. Step 1: Identify fact table role

    The fact table stores numeric measures such as sales amount, quantity, or counts.

  2. Step 2: Differentiate from dimension tables

    Dimension tables store descriptive attributes, not numeric measures.

  3. Final Answer:

    Fact table -> Option B

  4. Quick Check:

    Numeric measures = Fact table [OK]
Quick Trick: Measures live in fact tables, not dimensions [OK]
Common Mistakes:
  • Confusing dimension tables with fact tables
  • Thinking lookup or bridge tables hold measures
  • Assuming measures are stored in dimension attributes

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