Microsoft

PL-300
Microsoft Power BI Data Analyst
QUESTION & ANSWERS

https://www.dumpscollege.com/exam/PL-300
QUESTION 1

You need to create a relationship between the Weekly_Returns table and the Date table to meet the
reporting requirements of the regional managers. What should you do?
A. In the Weekly.Returns table, create a new calculated column named date-id in a format of
yyyymmddand use the calculated column to create a relationship to the Date table.
B. Add the Weekly_Returns data to the Sales table by using related DAX functions.
C. Create a new table based on the Date table where date-id is unique, and then create a many-to-
manyrelationship to Weekly_Return.

Correct Answer: A

Explanation/Reference:

Scenario: Region managers require a visual to analyze weekly sales and returns.
To relate the two tables we need a common column.

QUESTION 2

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.

https://www.dumpscollege.com/exam/PL-300
Correct Answer:

Explanation/Reference:

QUESTION 3

You have a report that includes a card visualization. You need to apply the following conditional
formatting to the card while minimizing design effort. For values that are greater than or equal to 100,
the font of the data label must be dark red. For values that are less than 100, the font of the data
label must be dark gray. Which type of format should you use?
A. Color scale
B. Rules

https://www.dumpscollege.com/exam/PL-300
C. Field value

Correct Answer: C

QUESTION 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 section, you will NOT be able to return to it. As a result, these
questions
will not appear in the review screen.
You have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook
contains
several Power View sheets.
You need to recreate the Power View sheets as reports in the Power Bl service.
Solution: Copy the workbook to Microsoft OneDrive for Business. From Excel, click Publish to Power Bl,
and
then click Upload
Does this meet the goal?
A. Yes
B. No

Correct Answer: B

QUESTION 5

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.

https://www.dumpscollege.com/exam/PL-300
Correct Answer: C

QUESTION 6

You import a large dataset to Power Query Editor.

You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point
A. Show whitespace
B. Column distribution
C. Column profile
D. Column quality
E. Monospaced

Correct Answer: A,D

QUESTION 7

You have a collection of reports for the HR department of your company.

You need to create a visualization for the HR department that shows a historic employee counts and
predicts
trends during the next six months.
Which type of visualization should you use?
A. scatter chart
B. ribbon chart
C. line chart
D. key influences

Correct Answer: C

Explanation/Reference:

The best data for forecasting is time series data or uniformly increasing whole numbers. The line chart
has to
have only one line.
Try forecasting: Try the new forecasting capabilities of Power View today on your own data or with the
sample report available as part of the Power BI report samples. To view your own data, upload a
workbook
with a Power View time series line chart to Power BI for Office 365.
Reference:
https://www.dumpscollege.com/exam/PL-300
https://powerbi.microsoft.com/en-us/blog/introducing-new-forecasting-capabilities-in-power-view-for-
office-365

QUESTION 8

You have a table that contains sales data and approximately 1,000 rows.
You need to identify outliers in the table. Which type of visualization should you use?
A. area chart
B. donut chart
C. scatter plot
D. pie chart

Correct Answer: C

Explanation/Reference:

Outliers are those data points that lie outside the overall pattern of distribution & the easiest way to
detect
outliers is though graphs. Box plots, Scatter plots can help detect them easily.
Reference:
https://towardsdatascience.com/this-article-is-about-identifying-outliers-through-funnel-plots-using-
the-microsoft-powe

QUESTION 9

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.)

https://www.dumpscollege.com/exam/PL-300
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.

Correct Answer: D

https://www.dumpscollege.com/exam/PL-300
Explanation/Reference:

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

QUESTION 10

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using
an
App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million
rows. The
dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 AppSource visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report.
You need to recommend a solution to improve the performance of the report.
What should you recommend?
A. Change any DAX measures to use iterator functions.
B. Replace the default visuals with AppSource visuals.
C. Change the imported dataset to DirectQuery.
D. Remove unused columns from tables in the data model.

Correct Answer: C

Explanation/Reference:

DirectQuery: No data is imported or copied into Power BI Desktop.

Import: The selected tables and columns are imported into Power BI Desktop. As you create or
interact with a
visualization, Power BI Desktop uses the imported data.
Benefits of using DirectQuery
There are a few benefits to using DirectQuery:
DirectQuery lets you build visualizations over very large datasets, where it would otherwise be
unfeasible to first import all the data with pre-aggregation.
Underlying data changes can require a refresh of data. For some reports, the need to display current
data
can require large data transfers, making reimporting data unfeasible. By contrast, DirectQuery reports
always use current data.
The 1-GB dataset limitation doesn't apply to DirectQuery.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

QUESTION 11

You have four sales regions. Each region has multiple sales managers.
You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to

https://www.dumpscollege.com/exam/PL-300
each
role.
You have sales reports that enable analysis by region. The sales managers can view the sales records
of their
region. The sales managers are prevented from viewing records from other regions.
A sales manager changes to a different region.
You need to ensure that the sales manager can see the correct sales data.
What should you do?
A. From Microsoft Power Bl Desktop, edit the Row-Level Security setting for the reports.
B. Change the Microsoft Power Bl license type of the sales manager.
C. Manage the permissions of the underlying dataset
D. Request that the sales manager be added to the correct Azure Active Directory group.

Correct Answer: D

Explanation/Reference:

Using AD Security Groups, you no longer need to maintain a long list of users.
All that you will need to do is to put in the AD Security group with the required permissions and Power
BI
will do the REST! This means a small and simple security file with the permissions and AD Security
group.
Note: Configure role mappings
Once published to Power BI, you must map members to dataset roles.
Members can be user accounts or security groups. Whenever possible, we recommend you map
security
groups to dataset roles. It involves managing security group memberships in Azure Active Directory.
Possibly,
it delegates the task to your network administrators.
Reference:
https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-
security-groups/
https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance

QUESTION 12

You are creating a quick measure as shown in the following exhibit.

https://www.dumpscollege.com/exam/PL-300
You need to create a monthly rolling average measure for Sales over time-How should you configure
the quick
measure calculation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

https://www.dumpscollege.com/exam/PL-300
Correct Answer:

Explanation/Reference:

Box 1: Total Sales

We select the field Total Sales
Box 2: Date
Select a date field.
Box 3: Month
Monthly periods.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures

https://www.dumpscollege.com/exam/PL-300
QUESTION 13

You have an app workspace named Retail Analysis in the Power BI service.
You need manage the members that have access to the app workspace.
What should you do?
A. From the Power BI Admin portal, click Usage metrics.
B. From the Office 365 Admin center, click Users.
C. From the Office 365 Admin center, click Groups.
D. From the Power BI Admin portal, click Tenant settings.

Correct Answer: C

Explanation/Reference:

References:
https://docs.microsoft.com/en-us/power-bi/service-manage-app-workspace-in-power-bi-and-office-365

QUESTION 14

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.

Correct Answer: A,D

Explanation/Reference:

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

https://www.dumpscollege.com/exam/PL-300
QUESTION 15

Your company plans to completely separate development and production assets such as datasets,
reports, and
dashboards in Microsoft Power Bl.
You need to recommend an application lifecycle strategy. The solution must minimize maintenance to
update
access and prevent end users from viewing the development assets.
What should you recommend?
A. Create production reports in a separate workspace that uses a shared dataset from the
developmentworkspace. Grant the end users access to the production workspace.
B. In the same workspace, create separate copies of the assets and append DEV to the names of the
copiedassets. Grant the end users access to the workspace.
C. Create separate workspaces for development and production. Grant the end users access to
theproduction workspace.
D. Create one workspace for development. From the workspace, publish an app for production.

Correct Answer: C

QUESTION 16

You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL
Server
database. The dashboard will be shared between the users in your organization.
You need to ensure that the users will see the current data when they view the dashboard.
How should you configure the connection to the data source?
A. Deploy an on-premises data gateway (personal mode). Import the data by using the Import
DataConnectivity mode.
B. Deploy an on-premises data gateway. Import the data by using the Import Data Connectivity
mode.
C. Deploy an on-premises data gateway. Import the data by using the DirectQuery Data
Connectivitymode.
D. Deploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery
DataConnectivity mode.

Correct Answer: D

Explanation/Reference:

References:
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#power-bi-connectivity-modes

https://www.dumpscollege.com/exam/PL-300
QUESTION 17

You have a large dataset that contains more than 1 million rows. The table has a datetime column
named
Date.
You need to reduce the size of the data model.
What should you do?
A. Round the hour of the Date column to startOfHour.
B. Change the data type of the Date column to Text.
C. Trim the Date column.
D. Split the Date column into two columns, one that contains only the time and another that contains
onlythe date.

Correct Answer: D

Explanation/Reference:

We have to separate date & time tables. Also, we don’t need to put the time into the date table,
because the
time is repeated every day.
Split your DateTime column into a separate date & time columns in fact table, so that you can join the
date to
the date table & the time to the time table. The time need to be converted to the nearest round
minute or
second so that every time in your data corresponds to a row in your time table.
Reference:
https://intellipaat.com/community/6461/how-to-include-time-in-date-hierarchy-in-power-bi

QUESTION 18

You need to create a relationship in the dataset for RLS.

What should you do? To answer select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer: See the answer as below in explanation.

https://www.dumpscollege.com/exam/PL-300
Explanation/Reference:

https://www.dumpscollege.com/exam/PL-300