Microsoft 70-778 Exam Practice Questions (P. 5)

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?

You use Power BI Desktop to create a visualization for a Microsoft SQL Server data source.
You need to ensure that you can use R visualization.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

You have a Power BI model that contains the following two tables:
✑ Sales(Sales_ID, sales_date, sales_amount, CustomerID)
✑ Customer(CustomerID, First_name, Last_name)
There is a relationship between Sales and Customer.
You need to create a measure to rank the customers based on their total sales amount.
Which DAX formula should you use?

You have a Microsoft SharePoint Online site named Sales.
Your company has 1,000 sales users. All the sales users can access Sales.
You create a report in an app workspace in the Power BI service. You embed the report into a page on the Sales site by using the Power BI web part.
You need to ensure that all the sales users can view the report from the Sales site.
What should you do?

You plan to deploy a Power BI app workspace that will be viewed by 10,000 users.
You need to ensure that dashboard data can be updated every 30 minutes.
What should you do?