Star and Snowflake Schema Basics Quiz

1. In a fact table, what do foreign keys typically reference?

Other fact tables

Dimension tables

Temporary staging tables

External databases

2. A fact table can contain both foreign keys and descriptive attributes.

True

False

3. Star schemas are generally easier to understand and navigate than snowflake schemas.

True

False

4. Which schema is preferred for OLAP (Online Analytical Processing) systems?

Star schema for simpler queries and faster performance

Snowflake schema for normalized data storage

Third normal form exclusively

Unstructured data models

5. What is the primary difference between a star schema and a snowflake schema?

Star schema has denormalized dimensions; snowflake schema has normalized dimensions

Star schema uses fact tables; snowflake schema does not

Star schema is only for small databases; snowflake schema scales to large databases

Star schema requires more storage; snowflake schema requires less storage

6. What is a slowly changing dimension (SCD)?

A dimension table that never changes

A dimension whose attributes change infrequently and must be tracked historically

A dimension that updates only once per year

A dimension used exclusively for date calculations

7. Which storage consideration favors a snowflake schema over a star schema?

Query speed is always faster

Reduced storage space due to normalization

Automatic data compression

Elimination of indexing requirements

8. In dimensional modeling, what does a bridge table handle?

Many-to-many relationships between dimensions and facts

One-to-one mappings only

Time-based sequences

Data compression algorithms

9. What is a conformed dimension?

A dimension used by only one fact table

A dimension shared consistently across multiple fact tables

A dimension that changes daily

A dimension stored in a normalized format

10. Which schema typically requires fewer joins when querying?

Snowflake schema

Star schema

Both require equal joins

Neither requires joins

11. In a snowflake schema, dimension tables are organized in what structure?

A single flat table per dimension

Normalized hierarchies with parent-child relationships

A circular reference pattern

An unstructured format

12. What does denormalization accomplish in a star schema?

Reduces query complexity and improves read performance

Eliminates the need for indexes

Ensures data consistency without constraints

Automatically backs up all dimension tables

13. Which of the following is a characteristic of a dimension table?

Contains numerical metrics and aggregates

Contains descriptive attributes used to filter and group data

Grows much larger than fact tables over time

Requires real-time updates every minute

14. In a dimensional model, what is a fact table?

A table containing descriptive attributes about entities

A table storing quantitative measurements and foreign keys to dimensions

A table used only for storing historical data

A normalized table following third normal form rules

15. Snowflake schemas always outperform star schemas in query execution speed.

True

False

Submit

Data+ Star and Snowflake Schema Basics Quiz

1. In a fact table, what do foreign keys typically reference?

2.

What first name or nickname would you like us to use?

2. A fact table can contain both foreign keys and descriptive attributes.

3. Star schemas are generally easier to understand and navigate than snowflake schemas.

4. Which schema is preferred for OLAP (Online Analytical Processing) systems?

5. What is the primary difference between a star schema and a snowflake schema?

6. What is a slowly changing dimension (SCD)?

7. Which storage consideration favors a snowflake schema over a star schema?

8. In dimensional modeling, what does a bridge table handle?

9. What is a conformed dimension?

10. Which schema typically requires fewer joins when querying?

11. In a snowflake schema, dimension tables are organized in what structure?

12. What does denormalization accomplish in a star schema?

13. Which of the following is a characteristic of a dimension table?

14. In a dimensional model, what is a fact table?

15. Snowflake schemas always outperform star schemas in query execution speed.

16. A ______ is a central table in a star schema containing business metrics.

17. In snowflake schemas, dimension normalization reduces ______ but increases query complexity.

18. A ______ dimension contains attributes that apply across multiple fact tables.

19. Star schemas typically use ______ dimensions to improve query performance.

20. A ______ table resolves many-to-many relationships in dimensional models.