Exam 70-778 topic 1 question 20 discussion

Actual exam question from Microsoft's 70-778

Question #: 20
Topic #: 1

You are creating a report in Power BI Desktop.
You are consuming the following tables.

You have a new table named Fiscal that has the same schema as the Date table, but contains the fiscal dates of your company.
You need to create a report that displays the total sales by fiscal month and calendar month.
What should you do?

A. Union Fiscal and Date as one table.
B. Add Fiscal to the model and create a one-to-many relationship by using Date[Year] and Fiscal[Year].
C. Add Fiscal to the model and create a one-to-one relationship by using Date[Year] and Fiscal[Year].
D. Merge Fiscal into the Date table.

Show Suggested Answer

Suggested Answer: D 🗳️
References:
https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

by Samewiss at Nov. 8, 2019, 9:01 a.m.

Comments

Submit Cancel

coupet

Highly Voted 5 years, 5 months ago

There are two primary ways of combining queries: merging and appending: - When you have one or more columns that you’d like to add to another query, you merge the queries. - When you have additional rows of data that you’d like to add to an existing query, you append the query.

upvoted 13 times

...

CDL

Most Recent 4 years, 7 months ago

D is correct. Why we merge table Date & Fiscal? Becoz after their merger, we will use the merge table as dimension table. And this merger dim Table will govern the Fact table Sales, and output us with regular calendar date and fiscal date.

upvoted 3 times

...

cromastro

4 years, 9 months ago

Another good example of needing to read the answers carefully. abellatif81 is correct. At first glance, the JOIN seems reasonable ... Except they give the wrong columns you would join on. And D is correct. You would MERGE and when you MERGE, you would use the DateKey.

upvoted 2 times

...

pbia

4 years, 10 months ago

Merge both queries based on date and fiscal date, then remove all other column except fiscal month. After this create two measure to calculate sales.

upvoted 1 times

...

devhawkio

5 years ago

I don't understand why this solution is C. Why merge when you can create a one-to-one relationship and have one table filter another, which filters the Sales data table? What is the expected output from a merge?

upvoted 2 times

abdellatif81

4 years, 10 months ago

It's not true answer C. Because the relationship should be based on datekey in that case and not on date[year]

upvoted 1 times

...

Faizal

5 years, 5 months ago

D. Merge both table.

upvoted 3 times

...

Samewiss

5 years, 6 months ago

https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

upvoted 1 times

...