Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 1 question 21 discussion

Actual exam question from Microsoft's DP-203

Question #: 21
Topic #: 1

HOTSPOT -
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:

Show Suggested Answer

Suggested Answer:

Box 1: DimEvent -

Box 2: DimChannel -

Box 3: FactEvents -
Fact tables store observations or events, and can be sales orders, stock balances, exchange rates, temperatures, etc
Reference:
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

by laszek at Aug. 29, 2021, 2:41 p.m.

Comments

Submit Cancel

gssd4scoder

Highly Voted 3 years, 2 months ago

It seems to be correct

upvoted 73 times

...

DingDongSingSong

Highly Voted 2 years, 9 months ago

What is this question? It is poorly written. I couldn't even understand what's being asked here. It talks about 4 tables, yet the answer shows 3. Then, the columns mentioned in the question don't match the column/attributes shown in the 3 tables noted in the answer.

upvoted 27 times

sdegcp

2 years, 6 months ago

Question says,including a dimTime table so we need to design only 3 tables.

upvoted 4 times

...

allagowf

2 years, 3 months ago

the question is clear try to read it again, there is no need to design DIM_DATE

upvoted 1 times

...

dgerok

Most Recent 9 months, 2 weeks ago

Correct answer

upvoted 1 times

...

Alongi

9 months, 3 weeks ago

Correct answer

upvoted 1 times

...

hassexat

1 year, 4 months ago

Correct provided answer

upvoted 1 times

...

kkk5566

1 year, 4 months ago

EventCategory -> dimEvent channelGrouping -> dimChannel TotalEvents -> factEven

upvoted 1 times

...

mamahani

1 year, 8 months ago

DimEvent / DimChannel / FactEvents

upvoted 1 times

...

SHENOOOO

1 year, 11 months ago

Category or Group will go with the table DIM, Total Events will go with the Fact

upvoted 2 times

...

Deeksha1234

2 years, 4 months ago

correct

upvoted 1 times

...

Rrk07

2 years, 7 months ago

EventCategory -> dimEvent channelGrouping -> dimChannel TotalEvents -> factEven

upvoted 4 times

...

Dothy

2 years, 8 months ago

EventCategory -> dimEvent channelGrouping -> dimChannel TotalEvents -> factEven

upvoted 1 times

...

JJdeWit

2 years, 8 months ago

EventCategory ==> dimEvent channelGrouping ==> dimChannel TotalEvents ==> factEvent Explanation: A bit of knowledge of Google Analytics Universal helps to understand this question. eventCategory, eventAction and eventLabel all contain information about the event/action done on the website, and can be logically be grouped together. ChannelGrouping is about how the user came on the website (through Google, and advertisement, an email link, etc.) and is not related to events at all. It therefore would make sense to put it in a second dim table.

upvoted 4 times

...

Mahesh_mm

3 years ago

Answer is correct

upvoted 4 times

...

laszek

3 years, 4 months ago

I would add ChannelGrouping to DimEvents table. What would DimChannel table contain? only one column? No sense to me

upvoted 4 times

manquak

3 years, 4 months ago

It is supposed to contain 4 tables. Date, Event, Fact so the logical conclusion would be to include the channel dimension. If it were up to me though I'd use the channel as a degenerate dimension and store it in fact table if it's the only information that we have provided.

upvoted 3 times

...

Seansmyrke

2 years, 10 months ago

I mean if you think about it, ChannelName (facebook,google,youtube), ChannelType (paid media, free posts, ads), ChannleDelivery (chrome, etc etc). Just thinking out loud

upvoted 1 times

...