Exam DP-300 All QuestionsBrowse all questions from this exam
Go to Exam
Question 14

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:

    Correct Answer:

    Box 1: DimEvent -

    Box 2: DimChannel -

    Dimension tables describe business entities ג€" the things you model. Entities can include products, people, places, and concepts including time itself. The most consistent table you'll find in a star schema is a date dimension table. A dimension table contains a key column (or columns) that acts as a unique identifier, and descriptive columns.

    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

Discussion
Aggie0702

Dimension tables support filtering and grouping, Fact tables support summarization, so the correct answer is: DimEvent, DimChannel, FactEvents.

learnazureportal

Answer is incorrect. The correct answer is: DimEvent, DimChannel, FactEvents

Sr18

Now its correct but, its DP 203

tesen_tolga

This is a DP-203 question.

SHABbirmohammed

Do we get these type of DP-203 questions in DP-300?

azure2022

DimEvent DimChannel FactEvents

kamilsky

From my opinion 1 and 3 are opposite - Fact is number of events and Event category is DimEvent.

Ciupaz

OLAP questions are not part of the DP-300 exam.

SQLHell

Its not a DP-300 Question !!

jerkyflexoff

Another, can this be fixed please.

gursimran_s

It's part of dp 300

gt002

Box 1: FactEvents - Box 2: DimChannel - Reference: https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

o2091

is part of DP-300???