- (Exam Topic 4)
You have a Microsoft Power Bl workspace.
You need to grant the user capabilities shown in the following table.
The solution must use the principle of least privilege.
Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role 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.
Solution:
User 1 = Member User 2 = Contributor
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces
Does this meet the goal?
Correct Answer:
A
- (Exam Topic 4)
Correct Answer:
A - (Exam Topic 4)
Correct Answer:
D - (Exam Topic 4)
Correct Answer:
A - (Exam Topic 4)
Correct Answer:
C
You have a Power BI report.
You need to create a calculated table to return the 100 highest spending customers.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Solution:
Box 1: TOPN
TOPN returns the top N rows of the specified table. Box 2: SUMMARIZE
SUMMARIZE returns a summary table for the requested totals over a set of groups. Box 3: DESC
Sort in descending order.
It is last in the TOPN command. TOPN syntax:
TOPN(,
https://docs.microsoft.com/en-us/dax/topn-function-dax
https://docs.microsoft.com/en-us/dax/summarize-function-dax
Does this meet the goal?
QUESTION 38
You maintain a Power Bl workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals.
The dashboard mobile layout is shown in the exhibit. (Click the Exhibit tab.)
You need to modify the dashboard mobile layout to meet the following requirements:
• Only show single-value visuals.
• Minimize scrolling. What should you do?
QUESTION 39
Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:
Access a published Power BI app Modify reports in an app workspace
Share dashboards created in My Workspace
You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.
Which license should you identify for each task? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Solution:
Graphical user interface, text, application, email Description automatically generated
References:
https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps https://docs.microsoft.com/en-us/power-bi/service-collaborate-power-bi-workspace
Does this meet the goal?
QUESTION 40
You have multiple dashboards.
You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design.
What should you use?
Microsoft Information Protection sensitivity labels provide a simple way for your users to classify critical
content in Power BI without compromising productivity or the ability to collaborate. Sensitivity labels can be applied to datasets, reports, dashboards, and dataflows. Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-security-sensitivity-label-overview