PL-300 Exam QuestionsBrowse all questions from this exam
Go to Exam

PL-300 Exam - Question 59

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 Answer
Correct 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

Discussion

17 comments
Sign in to comment
mindstemall
Oct 12, 2022

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.

learnazureportal
Oct 29, 2022

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.

Hoeishetmogelijk
Dec 13, 2022

you are both right

vivian_data
Jul 6, 2023

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

vivian_data
Jul 6, 2023

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

ZSun
Jul 10, 2023

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.

Bnxyl
Jul 21, 2023

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

Elfmo11
Sep 11, 2023

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.

HamzaMJ
Nov 13, 2022

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

KobeData
Nov 18, 2022

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.

scotchtapebunny
Nov 19, 2022

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.

Booster21
Nov 23, 2022

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.

Nandini_Shanthaveerappa
Oct 20, 2023

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

SamuComqi
Jul 20, 2023

I passed the exam today (948/1000). My answer was: - One-to-many - Single

UlyUkr
Apr 25, 2023

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.

Patrick666
Dec 6, 2022

One-to-many, both

SumaiyaShah
Dec 28, 2022

We cant make a 1 to 1 cardinality relationship single directional I guess

Mati_123
Mar 13, 2023

1 - One to Many 2- Single dirction

Shalaleh
May 2, 2023

one-to-many single

bakamon
Jun 7, 2023

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..

Lavi29
Jun 17, 2023

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.

Igetmyrole
Sep 5, 2023

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.

RazaTheLegend
Apr 12, 2023

1 - One to Many 2- Single direction

Bnxyl
Jul 21, 2023

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

Bnxyl
Jul 21, 2023

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

MoneyStacking
May 2, 2024

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!

Moin23
May 24, 2024

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

Mo2011
May 30, 2024

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

KipngenohVinnie
Jun 28, 2024

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

Flix
Jul 14, 2024

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.