Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 27 discussion

Actual exam question from Microsoft's PL-300

Question #: 27
Topic #: 2

HOTSPOT -
You are creating a Microsoft Power BI data model that has the tables shown in the following table.

The Products table is related to the ProductCategory table through the ProductCategoryID column. Each product has one product category.
You need to ensure that you can analyze sales by product category.
How should you configure the relationship from ProductCategory to Products? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: One-to-many -
The one-to-many and many-to-one cardinality options are essentially the same, and they're also the most common cardinality types.
Incorrect: A many-to-many relationship means both columns can contain duplicate values. This cardinality type is infrequently used. It's typically useful when designing complex model requirements. You can use it to relate many-to-many facts or to relate higher grain facts. For example, when sales target facts are stored at product category level and the product dimension table is stored at product level.

Box 2: Single -
Incorrect:
Bear in mind that bi-directional relationships can impact negatively on performance. Further, attempting to configure a bi-directional relationship could result in ambiguous filter propagation paths. In this case, Power BI Desktop may fail to commit the relationship change and will alert you with an error message.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

by Nourhan08 at Oct. 2, 2022, 12:11 p.m.

Comments

Submit Cancel

mindstemall

Highly Voted 2 years, 8 months ago

Silly comments here. One-to-many because several products have the same product category. Single because the performance is much better and the assignment states only that you need to be able to analyze sales by product category.

upvoted 108 times

SylUK

5 months, 1 week ago

Beside Both is for fact tables and Single for dimension tables.

upvoted 1 times

...

learnazureportal

2 years, 8 months ago

Your answer is correct. however, we don't choose single, b/c it has better performance. b/c data flows from product to ProductCategory. This is the reason, we choose single.

upvoted 23 times

Hoeishetmogelijk

2 years, 6 months ago

you are both right

upvoted 7 times

...

vivian_data

1 year, 11 months ago

How did we figure out that the data flows from Product to Product Category and not the other way around??

upvoted 1 times

vivian_data

1 year, 11 months ago

Nevermind, here's the answer: "For one-to-many relationships, the cross filter direction is always from the "one" side, and optionally from the "many" side (bi-directional). " https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

upvoted 12 times

i.eniolaabolade

8 months, 2 weeks ago

one "to" many

upvoted 1 times

...

ZSun

1 year, 11 months ago

This is the wrong explanation about "Single". When we choose one-to-many of "ProuctCat to Product", the default direction of single is from ProuctCat->Product. However, "analyzing sales by product category" means, information from sales->Product->ProductCat. This is the opposite direction of our single direction. Therefore, it should be Both. Keep in mind, the single direction is determined by your one-to-many design.

upvoted 8 times

Elfmo11

1 year, 9 months ago

But the direction is about the way the filter works. Since analysing sales by ProductCategory means you filter from ProductCategory (via Product) to Sales, the direction is one way from ProductCategory to Sales.

upvoted 5 times

...

Bnxyl

1 year, 11 months ago

Guys take note. This is tested and confirmed. At first, I wanted to abuse you but then something told me to first put it into practice. And yes. It is one to many and Both. Thank you for standing out

upvoted 5 times

...

HamzaMJ

Highly Voted 2 years, 7 months ago

1 - One to many because every product category has many products 2 - Both because we need to analyze sales by product category

upvoted 29 times

scotchtapebunny

2 years, 7 months ago

you want to analyse SALE BY PRODUCT CATEGORY, you need cross filter direction single to make this work. If you do both that means you want to analyze PRODUCT CATEGORY by SALE. This doesn't make sense so there is no need for both. You're going downstream from product category to sales not the other way around. This is what I think but I'd be thankful if someone can help me if I am wrong.

upvoted 27 times

Booster21

2 years, 7 months ago

I totally agree what you said that "If you do both that means you want to analyze PRODUCT CATEGORY by SALE.", otherwise single can do the trick. I was confused when to use BOTH earlier.

upvoted 2 times

...

Nandini_Shanthaveerappa

1 year, 8 months ago

For example, if we want to see the sales by product(Coffee, Tea, Milk) in each region(US, UK, IN). Say we dont want show the product names in the visuals if there no sales for that product in a specific region. So we use bidirectional so that the region and product tables are filtered for only sold products.. where it will not return blank if there's no sale for product tea in US .. it shows sales values for Coffee and Milk only

upvoted 1 times

...

KobeData

2 years, 7 months ago

Yu always filter from the one side, which in this case, is the productCategory. So one to many - single means filtering from one to the many side, which is correct. So it should be single. Hope this helps.

upvoted 5 times

...

l0cr

Most Recent 3 months, 3 weeks ago

Cross filter direction could be both, and that would provide a better report experience with the slicers in my opinion, but using single is the better performing and therefore default option.

upvoted 1 times

...

EpicData

8 months ago

Correct

upvoted 1 times

...

rcaliandro

10 months, 2 weeks ago

This is a classical single one-to-many relationship. The given answer is correct

upvoted 2 times

...

Flix

11 months, 2 weeks ago

One-to-many because several products have the same product category. Both, because the filter goes via Products and One-to-many is from product to category.

upvoted 1 times

...

KipngenohVinnie

1 year ago

The answer is correct, one to many, that is from ProductCategory to Products, and direction is Single

upvoted 2 times

...

Moin23

1 year, 1 month ago

Each product has one product category. isn't one-to-one ? They didn't say, every Product has "atleast" one product category configure the relationship from ProductCategory to Products? One - Product Category side Many on Product side ? right

upvoted 2 times

Mo2011

1 year ago

No, this means one category has many products so it one (category) to many (products)

upvoted 1 times

...

MoneyStacking

1 year, 1 month ago

For the Guys and Girls, At this page, you will no longer find any free questions from Examtopics. However, if you're hesitant about purchasing Contributor Access, don't hesitate any longer; buy it. It costs only $50 and provides a significant boost to your CV and career. I recently passed with a score of 917 out of 1000. Save yourself time by learning and memorizing all these questions, as 85% of the 50 exam questions were identical to those provided here. Cheers and good luck!

upvoted 1 times

...

Igetmyrole

1 year, 9 months ago

One-to-many Singel One-to-many: Each product category can have multiple products belonging to it. Single: Because we want to analyze sales by product category.

upvoted 2 times

...

Bnxyl

1 year, 11 months ago

After further analysis. I think there are two answers available to this Answer set A: One to many and Single Anwer SET B: One to one and both

upvoted 1 times

Bnxyl

1 year, 11 months ago

But thinking deeper, What is the, The product table and Product category table must be having a one to one cardinality otherwise this would mean that the Products table and sales table will be having a many to many relationship considering that they are related via the product ID. Thus to me the final answer should be One to one and then both directions

upvoted 1 times

...

Lavi29

2 years ago

It asks relationship from product category to product not vice versa. Filter will take place at many * direction. So keeping it one to many means product category to product one to many , which is wrong. As there is not an option of many to one then many to many is the best choice here. And for many to many we always need filter in both directions. So the answer is many to many and both.

upvoted 2 times

...

bakamon

2 years ago

question is asking ProductCategory to Product Relation.. For sure it will be one to many.. if it was product to productcategory, then it would be one to one and cross filter : single for performance..

upvoted 2 times

...

Shalaleh

2 years, 1 month ago

one-to-many single

upvoted 2 times

...

UlyUkr

2 years, 2 months ago

1. One to many, because one Product Category can have many Products. 2.Single. It allows to calculate Sales by Product Category. Also the best practice as per this article https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand Also I tested in Power BI. If you have doubts, recreate the issue in Power BI and you will get the correct answer.

upvoted 5 times

...

RazaTheLegend

2 years, 2 months ago

1 - One to Many 2- Single direction

upvoted 1 times

...

Mati_123

2 years, 3 months ago

1 - One to Many 2- Single dirction

upvoted 2 times

...

Load full discussion...