Practice Free PL-300 Exam Online Questions
You need to create relationships to meet the reporting requirements of the customer service department.
What should you create?
- A . an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
- B . an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]
- C . a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]
- D . a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id]
- E . a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]
A
Explanation:
Scenario: The customer service department requires a visual that can be filtered by both sales month and ship month independently.
Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
You create a Power Bl report1 named Summary1. You discover that Summary1 is slow.
You run Performance analyzer to identify performance metrics for Summary1
Which two metrics display the execution duration in Performance analyzer* Each correct answer present part of the solution. NOTE: Each correct answer is worth one point.
- A . Top Operations
- B . Dependencies
- C . Server requests
- D . DAX query
- E . Visual display
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?
- A . bar chart
- B . scatterplot
- C . pie chart
A
Explanation:
Scenario: The On-Time Shipping report will show the following metrics for a selected shipping month or quarter:
The percentage of orders that were shipped late by country and shipping region Customers that had multiple late shipments during the last quarter
Note: Bar and column charts are some of the most widely used visualization charts in Power BI. They can be used for one or multiple categories. Both these chart types represent data with rectangular bars, where the size of the bar is proportional to the magnitude of data values.
The difference between the two is that if the rectangles are stacked horizontally, it is called a bar chart. If the rectangles are vertically aligned, it is called a column chart.
Reference: https://www.pluralsight.com/guides/bar-and-column-charts-in-power-bi
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.
E
Explanation:
https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-the-service/
DRAG DROP
You have a Power BI model that contains a table named Sales.
Sales has the following three measures:
✑ A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is 32.89 million.
✑ A measure named Total Sales This Year that displays the sales from the current calendar year. The current value is 11.69 million.
✑ A measure named Total Sales Difference that uses a DAX formula of Sales[Last Year] C Sales[This Year].
You need to create the following visualization.
How should you configure the visualization? To answer, drag the appropriate measures to the correct fields. Each value 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.
Explanation:
Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts
You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
You need to load only the manufacturing reports to a table for analysis.
What should you do in Microsoft Power Bl Desktop?
- A . Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.
- B . Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.
- C . Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.
- D . Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.
B
Explanation:
We have to import Excel files from SharePoint, so we need the connector SharePoint folder which is used to get access to the files stored in the library. SharePoint list is a collection of content that has rows and columns (like a table) and is used for task lists, calendars, etc. Since we have to filter only on manufacturing reports, we have to select Transform and then filter by the corresponding folder path.
https://docs.microsoft.com/en-us/power-query/connectors/sharepointlist
HOTSPOT
You need to create a visualization to meet the reporting requirements of the sales managers.
How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Explanation:
Scenario: The sales managers require a visual to analyze sales performance versus sales targets.
Box 1: KPI
A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal.
Box 2: Sales[sales_amount]
Box 3: Date[month]
Time > FiscalMonth. This value will represent the trend.
Box 4: Targets[sales_target]
Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
HOTSPOT
You need to create a Power Bl report.
The first page or the report must contain the following two views:
* Sales By Postal Code
* Sales by Month
Both views must display a slicer to select a value for a field named Chain.
The Sales By Postal Code view must display a map visual as shown in the following exhibit.
You have a Power Bl report for the marketing department.
The report reports on web traffic to a blog and contains data from the following tables.
There is a one-to-many relationship from Posts to Traffic that uses the URL and URL Visited columns.
The report contains the visuals shown in the following table.
The dataset takes a long time to refresh.
You need to modify Posts and Traffic queries to reduce toad times.
Which two actions will reduce the toad times? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . Remove the rows in Traffic in which Traffic [Referring URL] does not start with "/"
- B . Remove the rows in Posts in which Post [Publish Date] is in the last seven days.
- C . Remove Traffic [IP Address], Traffic (Browser Agent], and Traffic [Referring URL).
- D . Remove Posts [Full Text] and Posts [Summary].
- E . Remove the rows in Traffic in which Traffic [URL visited] does not contain "blog”
You have a Power BI report. The report contains visualizations that have interactions. You need to identify which visualizations take the longest to complete.
What should you use?
- A . SQL Server Profiler
- B . Performance Analyzer in Power BI Desktop
- C . Query Diagnostics in Power BI
- D . Microsoft Edge DevTools
B
Explanation:
Use Power BI Desktop Performance Analyzer to optimize reports.
In Power BI Desktop you can find out how each of your report elements, such as visuals and DAX formulas, are performing. Using the Performance Analyzer, you can see and record logs that measure how each of your report elements performs when users interact with them, and which aspects of their performance are most (or least) resource intensive.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer