DP-203 Certification Practice Question #17

Question

From a website analytics system, you receive data extracts about user interactions such as downloads, link clicks, form submissions, and video plays.
The data contains the following columns.

You need to design a star schema to support analytical queries of the data. The star schema will contain four tables including a date dimension.
To which table should you add each column? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

In a star schema, measures and business events belong in the fact table, while descriptive attributes belong in dimensions. TotalEvents is the measure, so it belongs in FactEvent. EventCategory describes the type of user interaction and naturally belongs in DimEvent. channelGrouping describes acquisition or channel context rather than the event itself, so it fits a separate DimChannel, which also aligns with the prompt’s target of four tables including a date dimension.

More DP-203 practice questions