Online Access Free PL-300 Exam Questions

You have a Power BI dashboard that displays different visualizations of company sales.
You enable Q&A on the dashboard.
You need to provide users with sample questions that they can ask when using Q&A.
Which settings should you modify from the Power BI Settings?

• A.Dashboards
• B.Subscriptions
• C.Workbooks
• D.Datasets

Hotspot Question
You have an organization dimension named DimOrganizations.
You have four related tables as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
It is a snowflakeschema and DimOrgSubVertical is the only table that supports a hierarchy model for DimOrgVertical.

You need to create a visual that compares profit across 10 product categories for a selected quarter.
What is the best visual to use to achieve the goal?

• A.an area chart
• B.a funnel chart
• C.a line chart
• D.a clustered bar chart

Hotspot Question
You plan to use Power Query Editor to get data from an API.
The API returns a JSON response.
You have a username and password for the API.
Which data source and authentication method should you use to connect to the API? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Box 1: Web
To use Power Query Editor to get data from a web API, you'll first need to open the editor and select "From Web". Then, paste the API URL into the provided field and choose your desired authentication method (if needed). Finally, you'll navigate the parsed JSON data in the Power Query Editor to extract and transform the information into a usable format.
Box 2: Basic
Here's a more detailed breakdown:
1. Launching Power Query and Selecting "From Web":
Open Excel or Power BI Desktop.
Go to the "Data" tab and click "Get Data".
Select "From Other Sources" and then "From Web".
2. Inputting the API URL and Authentication:
In the "From Web" dialog, paste the URL of the API you want to access.
If the API requires authentication, you'll need to choose an appropriate authentication method (e.g., Anonymous, Basic, Windows).
Reference:
https://learn.microsoft.com/en-us/power-query/connectors/web/web

You have a Power Bl report hosted on powerbi.com that displays expenses by department for department managers.
The report contains a line chart that shows expenses by month.
You need to enable users to choose between viewing the report as a line chart or a column chart.
The solution must minimize development and maintenance effort.
What should you do?

• A.Create a mobile report that contains a column chart.
• B.Add a column chart, a bookmark, and a button for users to choose a visual.
• C.Enable report readers to personalize visuals.
• D.Create a separate report page for users to view the column chart.