Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 120 discussion

Actual exam question from Microsoft's 70-778

Question #: 120
Topic #: 1

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.

The following columns contain date information:
- Date[Month] in the mmyyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You need to create a relationship between the Monthly_returns table and Date[Date_ID].
What should you do before you create the relationship?

A. In the Date table, create a new calculated column named Month_ID that uses the yyyydd format.
B. In the Monthly_returns table, create a new calculated column named Date_ID that uses the ddmmyyyy format.
C. To the Order table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.
D. To the Date table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.

Show Suggested Answer

Suggested Answer: B 🗳️
References:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

by 3water at Aug. 18, 2019, 4:45 p.m.

Comments

Submit Cancel

lyniguez

Highly Voted 5 years ago

Answer should be D

upvoted 7 times

Maniula

1 year, 11 months ago

Can't be, there's no relationship between these columns and RELATED requires a relationship.

upvoted 1 times

...

CDL

Most Recent 4 years, 7 months ago

"Date"[Month] and "Mobth_return"[Month_ID] actually same data type "integer -> whole number", which satisfy the 1 to many relationship, and we dont have to do anything. and we use exclusion method, CD must be wrong, we cannot use RELATED before relationship created. A made no sense becoz why YYYYDD? where is the month? we only need Month here. the only option here is B, although I don't understand why we need an unnecessary move.

upvoted 3 times

...

AmandaW

4 years, 11 months ago

Why don't easily link Date[Month] and Monthly_returns[Month_ID]? They have the same data type and the same format.

upvoted 1 times

...

rathodn

4 years, 11 months ago

create a relationship for Monthly_returns table and Date[Date_ID]. column for Date table is already given and its ddmmyyyy. so B is correct. since we cannot figure out dd for monthly returns just add 01 to mmyyyy and it will be in ddmmyyyy format.

upvoted 2 times

...

J55889

4 years, 11 months ago

Answer should be D. The relationship between Month and day is one to many. So you can only add MONTH columns in DATE table.

upvoted 2 times

...

PowerLjubica

5 years ago

Is this a real question?! You can already make a relationship between the Date table and Monthly returns table with existing formats.

upvoted 3 times

...

claudia_learner

5 years, 1 month ago

I just tried it (using two tables Date and MonthlyReturns I have created using exactly the data types given) and found out that Power BI lets me create the relationship between Date[DateID] and MonthlyReturns[MonthID] even though they don't have common entries. I can also create correct graphs. So actually I don't have to do anything ?!?

upvoted 1 times

...

CYRUSD

5 years, 1 month ago

You need to add a column including first day of each month in Monthly return table

upvoted 1 times

...

azSinha

5 years, 1 month ago

y not d ?

upvoted 1 times

...

3water

5 years, 10 months ago

For Monthly_returns table, the lowest level is month, how come it create a new column with ddmmyyyy?

upvoted 3 times

Hien

5 years, 10 months ago

so the answer should be A

upvoted 1 times

OlaCharles

5 years, 9 months ago

The answer can also not be A because the Monthly_returns table has Date ID in mmyyyy format which is different from what we have in option A - yyyydd

upvoted 4 times

twane

5 years, 9 months ago

The question is: You need to create a relationship between the Monthly_returns table and Date[Date_ID]. NOT: You need to create a relationship between the Monthly_returns table and Date. In other words, if you are forced to use Date_Id you'll have to add a column....

upvoted 17 times

...

CorinnaK

5 years, 8 months ago

yes, the lowest level is month. so you can assume 01 as day and create a calculated column with format ddmmyyyy and then create the relationship

upvoted 7 times

...