microsoft pl-300 practice test

Microsoft Power BI Data Analyst

Last exam update: May 17 ,2024
Page 1 out of 23. Viewing questions 1-10 out of 224

Question 1

You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege.
Which role should you assign to the user?

  • A. Viewer
  • B. Admin
  • C. Contributor
  • D. Member
Mark Question:
Answer:

d

User Votes:
A
50%
B
50%
C
50%
D 3 votes
50%

Member role allows adding members or other with lower permissions to the workspace.

Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 2

You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:
Customer ID
Customer Name
Phone
Email Address
Address ID
Address contains the following columns:
Address ID
Address Line 1
Address Line 2
City
State/Region
Country
Postal Code
Each Customer ID represents a unique customer in the Customer table. Each Address ID represents a unique address in the Address table.
You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.
What should you do?

  • A. Merge the Customer and Address tables.
  • B. Group the Customer and Address tables by the Address ID column.
  • C. Transpose the Customer and Address tables.
  • D. Append the Customer and Address tables.
Mark Question:
Answer:

a

User Votes:
A 2 votes
50%
B 1 votes
50%
C
50%
D
50%

A merge queries operation joins two existing tables together based on matching values from one or multiple columns. You can choose to use different types of joins, depending on the output you want.

Reference:
https://docs.microsoft.com/en-us/power-query/merge-queries-overview

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 3

In Power BI Desktop, you are creating visualizations in a report based on an imported dataset.
You need to allow Power BI users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data.
What should you do?

  • A. From the Power BI service, configure the dataset permissions.
  • B. From Power BI Desktop, configure the Data Load settings for the current file.
  • C. From Power BI Desktop, modify the data source permissions.
  • D. From Power BI Desktop, configure the Report settings for the current file.
Mark Question:
Answer:

a

User Votes:
A 1 votes
50%
B
50%
C 1 votes
50%
D 1 votes
50%

Dataset permissions in the Power BI service
The table below describes the four levels of permission that control access to datasets in the Power BI service.
* Reshare
Allows user to share the content of the dataset with other users who will get read, reshare, or build permissions for it.
* Read
* Build
* Write
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-permissions

Discussions
vote your answer:
A
B
C
D
0 / 1000
3 months ago

By configuring the Report settings in Power BI Desktop, you can specify whether users are allowed to export summarized data or underlying data when interacting with the report in the Power BI service.


Question 4

You need to create a calculated column to display the month based on the reporting requirements.
Which DAX expression should you use?

  • A. FORMAT('Date'[date],MMM YYYY)
  • B. FORMAT('Date'[date_id],MMM) & & FORMAT('Date'[year], #)
  • C. FORMAT('Date'[date_id],MMM YYYY)
  • D. FORMAT('Date'[date],M YY)
Mark Question:
Answer:

a

User Votes:
A 1 votes
50%
B
50%
C 1 votes
50%
D
50%

Users must be able to see the month in each report as shown in the following example: Feb 2020.

Custom date/time formats -
The following format characters can be specified in the format_string to create custom date/time formats:
* mmm
Display the month as an abbreviation (Jan-Dec). Localized.
* yyyy
Display the year as a 4-digit number (100-9999).
* Etc.
Reference:
https://docs.microsoft.com/en-us/dax/format-function-dax#predefined-datetime-formats

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 5

You have a Microsoft Power BI 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 new transaction was added to the data source.
  • B. The dashboard tile cache refreshed.
  • C. A user added a comment to a tile.
  • D. A user pressed F5.
Mark Question:
Answer:

d

User Votes:
A
50%
B
50%
C
50%
D 1 votes
50%

If you press F5 or hit the refresh button, the dashboard charts gets updated.
Note: Power BI enables you to go from data to insight to action quickly, yet you must make sure the data in your Power BI reports and dashboards is recent.
Knowing how to refresh the data is often critical in delivering accurate results.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 6

HOTSPOT You have two CSV files named Products and Categories.
The Products file contains the following columns:
ProductID
ProductName
SupplierID
CategoryID
The Categories file contains the following columns:
CategoryID
CategoryName
CategoryDescription
From Power BI Desktop, you import the files into Power Query Editor.
You need to create a Power BI dataset that will contain a single table named Product. The Product will table includes the following columns:
ProductID
ProductName
SupplierID
CategoryID
CategoryName
CategoryDescription
How should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Mark Question:
Answer:

None


Box 1: Merge -
There are two primary ways of combining queries: merging and appending.
* When you have one or more columns that you'd like to add to another query, you merge the queries.
* When you have additional rows of data that you'd like to add to an existing query, you append the query.

Box 2: Disable the query load -

Managing loading of queries -
In many situations, it makes sense to break down your data transformations in multiple queries. One popular example is merging where you merge two queries into one to essentially do a join. In this type of situations, some queries are not relevant to load into Desktop as they are intermediate steps, while they are still required for your data transformations to work correctly. For these queries, you can make sure they are not loaded in Desktop by un-checking 'Enable load' in the context menu of the query in Desktop or in the Properties screen:
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-include-in-report-refresh

Discussions
0 / 1000

Question 7

You have the tables shown in the following table.

The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
Present ad impression counts for the day, campaign, and site_name. The analytics for the last year are required.
Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. Create one-to-many relationships between the tables.
  • B. Group the Impressions query in Power Query by Ad_id, Site_name, and Impression_date. Aggregate by using the CountRows function.
  • C. Create a calculated table that contains Ad_id, Site_name, and Impression_date.
  • D. Create a calculated measure that aggregates by using the COUNTROWS function.
Mark Question:
Answer:

ab

User Votes:
A 1 votes
50%
B 1 votes
50%
C
50%
D
50%

Incorrect:
Not C: A calculated table would increase the data model size.
Not D: Need Impression_date etc.

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 8

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. Enable visual interactions.
  • C. Replace the default visuals with AppSource visuals.
  • D. Split the visuals onto multiple pages.
Mark Question:
Answer:

d

User Votes:
A
50%
B
50%
C
50%
D 1 votes
50%

One page with many visuals may also make your report loading slow. Please appropriately reduce the number of visualizations on one page.
Reference:
https://community.powerbi.com/t5/Desktop/Visuals-are-loading-extremely-slow/td-p/1565668

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 9

You are creating a dashboard by using the Power BI service.
You have an existing report page that contains three charts.
You need to add the charts to the dashboard while maintaining the interactivity between the charts.
What should you do?

  • A. Edit interactions in the report and set all interactions to Filter.
  • B. Pin each chart as a tile.
  • C. Edit the dashboard theme and pin each chart as a tile.
  • D. Pin the report page as a live tile.
Mark Question:
Answer:

d

User Votes:
A
50%
B 1 votes
50%
C
50%
D
50%

One way to add a new dashboard tile is by pinning an entire report page. This is an easy way to pin more than one visualization at a time. Also, when you pin an entire page, the tiles are live; you can interact with them right there on the dashboard. And changes you make to any of the visualizations back in the report editor, like adding a filter or changing the fields used in the chart, are reflected in the dashboard tile as well.
Pinning live tiles from reports to dashboards is only available in Power BI service (app.powerbi.com).
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-live-tile-from-report

Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 10

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 five reports and two dashboards in a workspace.
You need to grant all organizational users read access to one dashboard and three reports.
Solution: You publish an app to the entire organization.
Does this meet the goal?

  • A. Yes
  • B. No
Mark Question:
Answer:

b

User Votes:
A
50%
B
50%

Instead: You create an Azure Active Directory group that contains all the users. You share each selected report and the one dashboard to the group.
Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-share-dashboards

Discussions
vote your answer:
A
B
0 / 1000
To page 2