<< Prev Question Next Question >>

Question 56/72

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

LEAVE A REPLY

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

Question List (72q)
Question 1: You create a report in the Power BI service. You plan to pro...
Question 2: You manage a Power BI model that has two tables named Sales ...
Question 3: You plan to deploy a Power BI app workspace that will be vie...
Question 4: You have a Power BI app named App1. The privacy for the App1...
Question 5: You plan to develop a Power BI report that has a bar chart t...
Question 6: You have a table named Sales. A sample of the data in Sales ...
Question 7: You have a sales report in an app workspace. The report disp...
Question 8: You need to create a dashboard in the Power BI service to di...
Question 9: You have a workspace that contains 10 dashboards. A dashboar...
Question 10: Note: This question is part of a series of questions that us...
Question 11: Your organization has a Microsoft Office 365 subscription. W...
Question 12: You are creating a report in Power BI Desktop. You are consu...
Question 13: You plan to create several datasets by using the Power BI se...
Question 14: You have a Power BI model that contains the following two ta...
Question 15: You need to create a custom visualization for Power BI. What...
Question 16: You are creating a report in Power BI Desktop. You are consu...
Question 17: From Power BI Desktop, you create a query that imports the f...
Question 18: You are creating a Power BI Desktop report that has several ...
Question 19: You have a Power BI report that displays a bar chart and a d...
Question 20: You attempt to publish a Microsoft Excel file to Power BI, a...
Question 21: You have a Power BI dashboard that displays different visual...
Question 22: Note: This question is part of a series of questions that us...
Question 23: Note: This question is part of a series of questions that pr...
Question 24: You have a Microsoft Excel spreadsheet that contains a table...
1 commentQuestion 25: You plan to use Power BI Desktop to create a report. The rep...
Question 26: You create a report in the Power BI service that displays th...
Question 27: Note: This question is part of a series of questions that pr...
Question 28: Note: This question is part of a series of questions that pr...
Question 29: You have a Power BI model that contains the following two ta...
Question 30: Your company has a custom line-of-business application named...
Question 31: You have a Microsoft SharePoint Online site named Sales. You...
Question 32: You plan to create a dashboard in the Power BI service that ...
Question 33: You have an app workspace that contains two datasets named d...
Question 34: You have an app workspace named Retail Store Analysis in the...
Question 35: Note: This question is part of a series of questions that pr...
Question 36: Your company has a security policy stating that proprietary ...
Question 37: You embed a Power BI report in a Microsoft SharePoint Online...
Question 38: Note: This question is part of a series of questions that us...
Question 39: Note: This question is part of a series of questions that us...
Question 40: Note: This question is part of a series of questions that us...
Question 41: Note: This question is part of a series of questions that us...
Question 42: You have a Power BI Desktop project that uses DirectQuery to...
Question 43: A data analyst publishes several Power BI visualizations to ...
Question 44: You have the visualization shown in the following exhibit. (...
Question 45: You have a table named Sales that contains sales data for th...
Question 46: You plan to join a fact table named ActivityLog to a Date di...
Question 47: Note: This question is part of a series of questions that us...
Question 48: You have a Power BI model that has a date table. A sample of...
Question 49: You have a Power BI report that is configured to use row-lev...
Question 50: You plan to create a dashboard in the Power BI service that ...
Question 51: You have a table in Power BI Desktop as shown in the followi...
Question 52: You plan to use Power BI Desktop optimized for Power BI Repo...
Question 53: You use Power BI Desktop to create a visualization for a Mic...
Question 54: You have a Power Pivot model that includes a KPI. You need t...
Question 55: Note: This question is part of a series of questions that pr...
Question 56: You plan to create a Power BI report. You have the schema mo...
Question 57: Note: This question is part of a series of questions that us...
Question 58: Note: This question is part of a series of questions that us...
Question 59: You have a Power BI model that contains the following two ta...
Question 60: Note: This question is part of a series of questions that pr...
Question 61: Note: This question is part of a series of questions that pr...
Question 62: You have a service published to a website. When you connect ...
Question 63: From the Home tab in Power BI Desktop, you click Enter Data ...
Question 64: You have two Microsoft SQL Server database servers named SQL...
Question 65: You have two tables named CustomerVisits and Date in a Power...
Question 66: You are creating a report in Power BI Desktop that has two v...
Question 67: Your company has several developers who plan to create custo...
Question 68: You have two tables named Customer and Orders. A sample of t...
Question 69: You have the following tables. (Exhibit) There is a many-to-...
Question 70: You have a Microsoft Excel 2016 workbook that has a Power Pi...
Question 71: You have a Power BI model for sales data. You create a measu...
Question 72: Note: This question is part of a series of questions that pr...