You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals. What should you set as the relationship cardinality?
There is one single product (with its own ID) in the Product catalog but there could be many rows in the revenue data for that product (one per each date there is a revenue for the product) as it's detailed "revenue data is provided at the date and product level."
D - One to Many
The relevant info is: Revenue data is provided at the date and product level.
This means, we can expect a table of the length [dates * products] (at max, because there might be days where some products didn't generate revenue).
The product list has one line per product. So when creating a relationship, it is one-to-many.
that sentence is very important. allows you go realize each row of revenue corresponds to one row in products, but one row in product can correspond to many rows in revenue
When creating the relationship between the product catalog and the revenue results tables, the relationship cardinality should be set to Many-to-Many. This is because there may be multiple products associated with each revenue result and multiple revenue results associated with each product.
In that case, since the revenue data is coming from the Azure SQL database and the product catalog data is coming from Microsoft Dynamics 365, you will need to create a composite model in Power BI.
Guys! If it were before, I would also go with D! but here we have two data source!!! it means we have composite dataset!!! when we have two table from two different data sources, the relationship between them in Many-to- Many.
Please correct me, if I am wrong!
Please does anyone knows how to quickly understand the requirement of a case study. It is too long for me. I guess there is way around understanding it. Thank you!
This section is not available anymore. Please use the main Exam Page.PL-300 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
NotMeAnyWay
Highly Voted 2 years, 6 months agoDani_eL
Highly Voted 1 year, 1 month agod3bef3e
1 year agojaume
Most Recent 5 months, 1 week ago28485e1
1 year, 1 month agotaod
1 year, 8 months agoab97776
1 year agoShalaleh
1 year, 12 months agoShalaleh
2 years agoShalaleh
2 years agoShalaleh
2 years agoHeshybay
2 years, 2 months agosa56
2 years agoyordiye
2 years, 3 months agolukelin08
2 years, 5 months agodisndat7
2 years, 5 months ago