Multiple choice

What are the two types of tables involved in producing a star schema?

  1. Fact tables and user tables

  2. Dimension tables and error tables

  3. Fact tables and dimension tables

  4. User tables and error tables
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A star schema in data warehousing consists of fact tables (containing quantitative measurements and foreign keys) and dimension tables (containing descriptive attributes). Fact tables connect to multiple dimension tables in a star-like pattern.

Keep practicing — related questions