Exam 70-778 All Questions

View all questions & answers for the 70-778 exam

Exam 70-778 topic 1 question 37 discussion

Actual exam question from Microsoft's 70-778

Question #: 37
Topic #: 1

DRAG DROP -
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 exactly the same in each question in this series.
Start of repeated scenario.
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit button.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit button.)

You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory[Subcategory] contains NULL values.
End of Repeated Scenario.
You implement the Power BI model.
You need to create a hierarchy that has Category, Subcategory, and Product.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Select and Place:

Show Suggested Answer

Suggested Answer:

References:
https://intelligentsql.wordpress.com/2013/05/08/tabular-hierarchies-across-multiple-tables/ https://www.desertislesql.com/wordpress1/?p=1629

by TiaanR at July 9, 2019, 8:49 a.m.

Comments

Submit Cancel

TiaanR

Highly Voted 5 years, 11 months ago

My solution would be: 1. Create column in Product called Category with RELATED DAX 2. Create column in Product called SubCategory with RELATED DAX 3. Create Hierarchy

upvoted 72 times

SteveKarr

5 years, 11 months ago

Sequence is important for this answer. First you have to create product sub category column as there is no direct relationship between product and category. Next create product category then hierarchy.

upvoted 16 times

Hien

5 years, 10 months ago

RELATED DAX function does not care how long the many to 1 relationship a long the chain, see this link https://docs.microsoft.com/en-us/power-bi/guided-learning/introductiontodax?tutorial-step=5#step-0 inside the video.

upvoted 6 times

sumitmalik

5 years ago

THANKS

upvoted 1 times

...

Maniula

1 year, 11 months ago

Even if you were right, there're are other answers with direct relationship between tables so why would you use the indirect one ?!!

upvoted 1 times

...

Leong

Highly Voted 5 years, 10 months ago

Agree with TiaanR. A hierarchy created from columns need to be in the same table. Once with have all the 3 columns, right click the Category to create the hierarchy .

upvoted 9 times

...

OompaLoompa

Most Recent 4 years, 4 months ago

2-5-4 and 5-2-4. Create calculated COLUMNS not MEASURES.

upvoted 1 times

...

Lhouss

4 years, 6 months ago

2-5-4 and 5-2-4.

upvoted 1 times

...

jackPee

4 years, 8 months ago

Well, I get an error trying to use RELATED within a measure. So, I've created 2 Colums in the Product-Table (Category & SubCategory) than made a hierarchy and it has worked. Now, the answer requires an order. In my opinion, it makes absolutely no difference if I create Category or SubCategory at first. What should be done first? SubCategory or Category? The right answer by the way is "create RELATED(SUBCATEGORY) in Product Table, create RELATED(CATEGORY) in Product Table and create hierarchy". But how to order the first 2 would be great to know with arguments, please!

upvoted 1 times

maybelline_ny

4 years, 7 months ago

Because there's no direct relationship between Product and Product Category? That's why the subcategory goes first

upvoted 1 times

...

Debjit

4 years, 10 months ago

Why should we create measure? As per my understanding the answer should be 5,2,4

upvoted 1 times

...

123

4 years, 12 months ago

See comment from 07071996. http://community.powerbi.com/t5/Desktop/if-then-else/td-p/117999

upvoted 1 times

...

Shanuramasubbu

4 years, 12 months ago

5-2-4 is correct https://intelligentsql.wordpress.com/2013/05/08/tabular-hierarchies-across-multiple-tables/

upvoted 1 times

...

PowerLjubica

5 years ago

1.Create column in Product table (Related Category) 2.Create column in Product table (Related SubCategory) 3. Create hierarchy. TESTED!

upvoted 7 times

123

5 years ago

I would agree; doesn't the SUB category come AFTER the category? I'm with you - and TiaaR

upvoted 1 times

...

07071996

5 years ago

1-Create column ProductSubCategory in Product table: ProductSubCategory = RELATED(DimProductSubcategory[EnglishProductSubcategoryName]) 2-Create column ProductCategory in Product table: ProductCategory = RELATED(DimProductCategory[EnglishProductCategoryName]) 3-Create Hierarchy by Dragging and Dropping these columns to EnglishProductName. https://community.powerbi.com/t5/Desktop/How-to-create-Hierarchy/m-p/479991#M223381

upvoted 4 times

...

Abains

5 years, 3 months ago

https://intelligentsql.wordpress.com/2013/05/08/tabular-hierarchies-across-multiple-tables/

upvoted 1 times

...

lozqt

5 years, 3 months ago

The solutions states that 6-1-4 are the correct answers... I have an issue with 6, I would replace it by 5 because action 6 cannot be done. The Product Table and the Product Categrory Table do not have a Relationship hence the RELATED function does not work between these two tables. However it is the contrary between Product Table and Product Subcategory Table hence the RELATED function works... Anyone else agrees with this ? Correct answers being 5 --> 1 --> 4

upvoted 2 times

...

siqi

5 years, 3 months ago

Agree with TiaanR and mohroshdy

upvoted 1 times

...

Dirk

5 years, 3 months ago

So - I found this here in the community: https://community.powerbi.com/t5/Desktop/hierarchy-with-measures/m-p/554671#M261224 Looks somehow that it will really work with measures... Maybe someone can explain the way it works for Dummies ...

upvoted 1 times

...