- (Topic 4)
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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.
You need to create a reference line to show which employees are above the median salary.
Solution: You create a percentile line by using the Salary measure and set the percentile to 50%.
Does this meet the goal?
Correct Answer:
A
The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.
Reference:
https://dash-intel.com/powerbi/statistical_functions_percentile.php
- (Topic 4)
You have a Power BI model that contains a table named Sales. The Sales table contains the following columns:
• Order Line ID
• Product ID
• Unit Price
• Order ID
• Quantity
Orders are uniquely identified by using the order ID and can have multiple order lines Each order line within an order contains a different product ID.
You need to write a DAX measure that counts the number of orders. Which formula should you use?
Correct Answer:
D
- (Topic 4)
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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have several reports and dashboards in a workspace.
You need to grant all organizational users read access to a dashboard and several reports. Solution: You create an Azure Active Directory group that contains all the users. You share
each report and dashboard to the group. Does this meet the goal?
Correct Answer:
A
Statements and questions are tricky and confusing. When the access is granted for the group (all users) for ALL (each) dashboards and ALL (each) reports in the workspace, then the will have read access to the specific (A, one) Dashboard and several reports, because they are part of all dashboards and reports. There is no statement, that for the other dashboards (except the one) and the other reports (except the several) that access must be prevented. They are also accessible (maybe it is not desired but not stated here).
- (Topic 4)
In Power Bi Desktop, you are creating visualizations in a report based on an imported dataset
You need to allow Power Bi users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data
What should you do?
Correct Answer:
C
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization- export-data?tabs=powerbi-desktop
The export functionality can be disabled on several levels. First, Power BI Service admins can disable this functionality on tenant level. With that, nobody will be able to export the data. More about that later. Second, as a dataset owner you can decide if you allow your users to export the data. This is managed in dataset settings, but only changeable in Power BI desktop.
No matter what settings are applied in Power BI desktop, the tenant settings will overrule this. In the end the Power BI Service admin decides what options are possible to use.
https://data-marc.com/2020/04/13/power-bi-governance-why-you-should-consider-to- disable-export-to-excel/
- (Topic 4)
You have a Power Bl workspace that contains several reports.
You need to provide a user with the ability to create a dashboard that will use the visuals from the reports.
What should you do?
Correct Answer:
B
