Microsoft PL-300 Microsoft Power BI Data Analyst Online Training

Microsoft PL-300 Online Training

The questions for PL-300 were last updated at Nov 26,2024.

Exam Code: PL-300
Exam Name: Microsoft Power BI Data Analyst
Certification Provider: Microsoft
Latest update: Nov 26,2024

Question #71

You are creating a visual to show the ranking of product categories by sales revenue.

Your company’s security policy states that you cannot send data outside of your Microsoft Power Bl tenant

Which approach provides the widest variety of visuals while adhering to the security policy?

A . Use default visuals or custom visuals uploaded from a .pbiviz file.
B . Use only default visuals.
C . Use default or any custom visuals from the marketplace.
D . Use default or certified custom visuals.

Reveal Solution Hide Solution

Correct Answer: C

Question #72

You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source.

The dashboard is shown in the exhibit. (Click the Exhibit tab.)

What occurred at 12:03:06 PM?

A . A user pressed F5
B . A new transaction was added to the data source.
C . A user added a comment to a tile.
D . The dashboard tile cache refreshed.

Reveal Solution Hide Solution

Correct Answer: A
A

Explanation:

Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

Question #73

You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages.

What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A . Sync the slicers across the pages.
B . Replace the slicers with page-level filters.
C . Replace the slicers with visual-level filters.
D . Create a bookmark for each slicer value.
E . Replace the slicers with report-level filters.

Reveal Solution Hide Solution

Correct Answer: AE
AE

Explanation:

Add a report-level filter to filter an entire report.

The visuals on the active page, and on all pages in the report, change to reflect the new filter.

You can sync a slicer and use it on any or all pages in a report.

Question #73

A . Sync the slicers across the pages.
B . Replace the slicers with page-level filters.
C . Replace the slicers with visual-level filters.
D . Create a bookmark for each slicer value.
E . Replace the slicers with report-level filters.

Reveal Solution Hide Solution

Question #75

You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to ensure that the users can consume the content on a report page in a logical order.

What should you configure in Microsoft Power Bl Desktop?

A . the bookmark order
B . the layer order
C . the tab order
D . the X position

Reveal Solution Hide Solution

Correct Answer: C
C

Explanation:

If you find yourself unable to navigate to an object or visual while using a keyboard, it may be because the report author has decided to hide that object from the tab order. Report authors commonly hide decorative objects from the tab order. If you find that you cannot tab through a report in a logical manner, you should contact the report author. Report authors can set the tab order for objects and visuals.

Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-consuming-tools

Question #76

You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications.

What should you do?

A . Share the dashboard to the user.
B . Create a subscription.
C . Create a data alert.
D . Tag the user in a comment.

Reveal Solution Hide Solution

Correct Answer: C
C

Explanation:

You can subscribe yourself and your colleagues to the report pages, dashboards, and paginated reports that matter most to you. Power BI e-mail subscriptions allow you to:

Decide how often you want to receive the emails: daily, weekly, hourly, monthly, or once a day after the initial data refresh.

Choose the time you want to receive the email, if you choose daily, weekly, hourly, or monthly.

Note: Email subscriptions don’t support most custom visuals. The one exception is those custom visuals that have been certified.

Email subscriptions don’t support R-powered custom visuals at this time.

Incorrect Answers:

A: Set data alerts to notify you when data in your dashboards changes beyond limits you set.

Reference:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-report-subscribe

https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

Question #77

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 (Pll). The solution must minimize configuration effort and impact on the dashboard design.

What should you use?

A . Active Directory groups
B . tiles
C . data classifications
D . comments

Reveal Solution Hide Solution

Correct Answer: A

Question #78

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?

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

Reveal Solution Hide Solution

Correct Answer: E
E

Explanation:

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

Question #79

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A . Add the same slicer to each page and configure Sync slicers.
B . Edit the interactions of the KPI visualization.
C . Configure a page-level filter.
D . Edit the interactions of the slicer that is on the same page as the KPI visualization.
E . Configure a report-level filter.

Reveal Solution Hide Solution

Correct Answer: AD
AD

Explanation:

Slicers are another way of filtering. They narrow the portion of the dataset that is shown in the other report visualizations.

By default, slicers on report pages affect all the other visualizations on that page, including each other. Use visual interactions to exclude some page visualizations from being affected by others.

Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers

Question #80

You have a Microsoft Power Bl dashboard.

You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard.

What should you use?