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?

A. One to one

B. Many to many

C. Many to one

D. One to many








 

Suggested Answer: D

One product in the product list can occur many times in the revenue results.
Note 1: One to many (1:*): In a one-to-many relationship, the column in one table has only one instance of a particular value, and the other related table can have more than one instance of a value.
Note 2:
Revenue data is provided at the date and product level.
The board must be able to get the following information from the quarterly reports:
Revenue trends over time -
The percent of total revenue contributed by each product category
A comparison of quarterly revenue versus the same quarter from the previous year
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

This question is in PL-300 Microsoft Power BI Data Analyst Exam
For getting Microsoft Certified: Power BI Data Analyst Associate Certificate







Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.