Pass with professional 070-778 actual quiz materials

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?

• A. Change the Cross filter direction to Both.
• B. Change the Cardinality to One to Many (1:*).
• C. Select Assume Referential Integrity.
• D. Change the Cardinality to One to one (1:1).

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date.
The tables have the following relationships:
The active relationship is on Sales[DueDate].
You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.
Solution: You create measures that use the CALCULATE, COUNT, and FILTER DAX functions.
Does this meet the goal?

• A. No
• B. Yes

Your organization has a team of power users who recently created 20 Power BI dashboards.
The power users share the dashboards with other users in the organization.
When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)

You need to ensure that all the users can access the dashboards.
What should you do first?

• A. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.
• B. From the properties of each dashboard, modify the Share dashboard settings.
• C. Instruct each user to install Microsoft Office 2016.
• D. From the Power BI Admin portal, modify the Privacy Settings.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date.
The tables have the following relationships:
The active relationship is on Sales[DueDate].
You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data.
Solution: You create two copies of the Date table named ShipDate and OrderDateGet. You create a measure that uses the new tables.
Does this meet the goal?

• A. No
• B. Yes

You have three Power BI Desktop projects named Reportl.pbix, Report2.pbix, and Report3.pbix that have the following characteristics:
* Report1.pbix contains a custom visualization.
* Report2.pbix implements row-level security.
* Report3.pbix connects to a Microsoft SQL Server database by using DirectQuery.
Which reports support Publish to Web, and which reports can be published to Power BI Report Server? To answer, drag the appropriate reports to the correct targets. Each report may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.