BenchMark Quizzes by MDFT Pro

Design A Star Schema

You work for MDFT Pro, a well-known training agency with an extensive online learning platform. Mark, the Director of Analytics, has hired you to design a star schema for analyzing student engagement on the company’s website.

The analytics system captures user interactions such as video plays, document downloads, quiz submissions, and forum posts. The data extracts include event categories, actions, labels, channel sources, and various metrics. Mark wants you to create a four-table star schema (including a date dimension) that will support efficient analytical queries for understanding how students interact with course materials.

The interaction data contains the following columns:

Column name	Sample data
Date	Dec 12, 2025
EventCategory	Videos
EventAction	Play
EventLabel	Educational
ChannelGrouping	LMS
TotalEvents	150
UniqueEvents	120
SessionsWithEvents	90

Which of the following statements about the star schema are correct?

Choose all correct answers from the options below.

Explanations for each answer:

EventCategory should be added to table FactEvent is incorrect. EventCategory is a descriptive attribute that should be in a dimension table (DimEvent), not in the fact table.
EventCategory should be added to table DimEvent is correct. EventCategory is a descriptive attribute that belongs in the dimension table DimEvent, following star schema best practices.
TotalEvents should be added to table FactEvent is correct. TotalEvents is a numeric measure that should be stored in the fact table FactEvent, as it represents quantitative data.
TotalEvents should be added to table DimEvent is incorrect. TotalEvents is a numeric measure, not a descriptive attribute, so it belongs in the fact table, not the dimension table.
EventLabel should be added to table FactEvent is incorrect. EventLabel is a descriptive attribute that should be in a dimension table (DimEvent), not in the fact table.
EventLabel should be added to table DimEvent is correct. EventLabel is a descriptive attribute that belongs in the dimension table DimEvent, following star schema design principles.

Learn more about Star Schema Design:

Star Schema Design

Practice Exam

Design A Star Schema

Discuss this question on social media: