Microsoft
70-778 · Question #36
70-778 Question #36: Real Exam Question with Answer & Explanation
Sign in or unlock 70-778 to reveal the answer and full explanation for question #36. The question stem and answer options stay visible for context.
Question
You plan to create a Power BI report. You have the schema model shown in the exhibit. (Click the exhibit). The model has the following relationships: Store the District based on DistrictID Sales to Store based on LocationID 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 sales report, they see Sales by Items for all stores. You need to ensure that the district managers can see Sales by items for the stores they manage only. How should you configure the relationship from Sales to Item?
Exhibit
Options
- AChange the Cardinality to One to one (1:1).
- BChange the Cardinality to One to Many (1.*).
- CSelect Assume Referential Integrity.
- DChange the Cross filter direction to Both.
Unlock 70-778 to see the answer
You've previewed enough free 70-778 questions. Unlock 70-778 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.