How should you configure the relationship from Sales to Item?

You plan to create a Power BI report. You have the schema model shown in the exhibit. (Click the Exhibit button.)

The model has the following relationships:
• Store to District based on DistrictID
• Sales to Store based on LocationlD
• Sales to Date based on PeriodID
• Sales to Item based on ItemID
You configure row-level security (RLS) so that the district managers of the stores only see the sales from the stores they manage. When the district managers view the Store by Items report, they see items for all the stores.
You need to ensure that the district managers can see items for the stores they manage only.
How should you configure the relationship from Sales to Item?
A. Select Assume Referential Integrity
B. Change the Cardinality to One to Many (1 :*).
C. Change the Cross filter direction to Both.
D. Change the Cardinality to One to one (1:1).

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.