ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-203 All Questions

View all questions & answers for the DP-203 exam
Go to Exam

Exam DP-203 topic 1 question 21 discussion

Actual exam question from Microsoft's DP-203
Question #: 21
Topic #: 1
[All DP-203 Questions]

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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
gssd4scoder
Highly Voted 2 years, 11 months ago
It seems to be correct
upvoted 73 times
...
DingDongSingSong
Highly Voted 2 years, 6 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, 3 months ago
Question says,including a dimTime table so we need to design only 3 tables.
upvoted 4 times
...
allagowf
2 years ago
the question is clear try to read it again, there is no need to design DIM_DATE
upvoted 1 times
...
...
dgerok
Most Recent 6 months, 3 weeks ago
Correct answer
upvoted 1 times
...
Alongi
7 months ago
Correct answer
upvoted 1 times
...
hassexat
1 year, 1 month ago
Correct provided answer
upvoted 1 times
...
kkk5566
1 year, 1 month ago
EventCategory -> dimEvent channelGrouping -> dimChannel TotalEvents -> factEven
upvoted 1 times
...
mamahani
1 year, 5 months ago
DimEvent / DimChannel / FactEvents
upvoted 1 times
...
SHENOOOO
1 year, 8 months ago
Category or Group will go with the table DIM, Total Events will go with the Fact
upvoted 2 times
...
Deeksha1234
2 years, 2 months ago
correct
upvoted 1 times
...
Rrk07
2 years, 4 months ago
EventCategory -> dimEvent channelGrouping -> dimChannel TotalEvents -> factEven
upvoted 4 times
...
Dothy
2 years, 5 months ago
EventCategory -> dimEvent channelGrouping -> dimChannel TotalEvents -> factEven
upvoted 1 times
...
JJdeWit
2 years, 5 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
2 years, 9 months ago
Answer is correct
upvoted 4 times
...
laszek
3 years, 1 month 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, 1 month 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, 7 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
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago