- (Exam Topic 4)
You have a Power BI tenant.
You have reports that use financial datasets and are exported as PDF files. You need to ensure that the reports are encrypted.
What should you implement?

1. A. dataset certifications
2. B. row-level security (RLS)
3. C. sensitivity labels
4. D. Microsoft Intune policies

Correct Answer: C
General availability of sensitivity labels in Power BI.
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 on datasets, reports, dashboards, and dataflows. When data is exported from Power BI to Excel, PowerPoint or PDF files, Power BI automatically applies a sensitivity label on the exported file and protects it according to the label’s file encryption settings. This way your sensitive data remains protected no matter where it is.
Reference:
https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-data-protection-ga-and-introducing-new-capabil

- (Exam Topic 4)
You have a Power BI model that has the following tables:
Product (Product_id, Product_Name)
Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount)
Salesperson (Salesperson_id, Salesperson_name, address)
You plan to create the following measure. Measure1 = DISTINCTCOUNT(Sales[ProductID]) You need to create the following relationships:
Sales to Product
Sales to Salesperson
The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson. How should you configure the relationships? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Solution:
Graphical user interface, text Description automatically generated

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 4)
You need to create the On-Time Shipping report.
The report must include a visualization that shows the percentage of late orders. Which type of visualization should you create?

1. A. scarterplot
2. B. bar chart
3. C. piechart

Correct Answer: B

- (Exam Topic 4)
You plan to create the chart shown in the following exhibit.

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

1. A. Create a horizontal line that has a fixed value of 24,000.
2. B. Add a measure to the visual that uses the following DAX expression.Heasurel - PERCENTUEX.EXC (Sales,Sales[Total Sales],©.40)
3. C. Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.
4. D. Add a measure to the visual that uses the following DAX expression.Heasurel = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)

Correct Answer: C
The analytics feature enables you to show percentiles across groups specified along a specific axis. Example:
* 1. Click on the analytics tab
* 2. Select Percentile
* 3. You can choose a specific percentile along with other formatting options.
* 4. Drag a date or non-numeric dimension into the Axis of a column chart


Add percentile lines to monitor daily revenue

- (Exam Topic 4)
You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer services department of your company.
You need to ensure that customer service managers can create task lists in Microsoft Excel based on the data. Which report setting should you configure?

1. A. Don't allow end user to save filters on this report.
2. B. Change default visual interaction from cross highlighting to cross filtering.
3. C. Enable the updated filter pane, and show filters in the visual header for this report.
4. D. Allow users to add comments to this report.
5. E. Choose the type of data you allow your end users to export.

Correct Answer: E
https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-the-service/