Hotspot 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 c

Sign in or unlock DP-300 to reveal the answer and full explanation for question #135. The question stem and answer options stay visible for context.

Submitted by lucia.co· Mar 6, 2026Plan and implement data platform resources

Question

Hotspot 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. Answer:

Exhibits

Answer Area

Date
Fact TableDate DimensionEvent DimensionChannel Dimension
EventCategory
Fact TableDate DimensionEvent DimensionChannel Dimension
EventAction
Fact TableDate DimensionEvent DimensionChannel Dimension
EventLabel
Fact TableDate DimensionEvent DimensionChannel Dimension
ChannelGrouping
Fact TableDate DimensionEvent DimensionChannel Dimension
TotalEvents
Fact TableDate DimensionEvent DimensionChannel Dimension
UniqueEvents
Fact TableDate DimensionEvent DimensionChannel Dimension
SessionsWithEvents
Fact TableDate DimensionEvent DimensionChannel Dimension

Unlock DP-300 to see the answer

You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Unlock DP-300 - $49.99 / 30 days Sign in

Topics

#Star schema#data warehousing#fact table#dimension table#data modeling

Full DP-300 Practice