Multiple choice technology platforms and products

What is a star schema

  1. contains multiple facts & dimensions

  2. contains a single fact & one or multiple dimensions

  3. contains single dimension & multiple facts

  4. none
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A star schema is a dimensional model containing a single fact table at the center surrounded by one or more dimension tables. Models with multiple fact tables are typically called galaxy or fact constellation schemas. Therefore, the option describing a single fact and one or multiple dimensions is correct.

Keep practicing — related questions