PL-300 MICROSOFT POWER BI DATA ANALYST QUESTIONS AND ANSWERS

Name: Score:


81 Multiple choice questions

Term 1 of 81
#44.5 Question
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?

pie chart

scatterplot


bar chart

Term 2 of 81
#43.4
CALCUTALE
FILTER
. . . [ShippedDate] > . . .

#45 last

* Gran access by: Using a workspace memership
* A mail-enabled


#44.2

one-to-many . . . Orders table


#43.4
CALCUTALE
FILTER
. . . [ShippedDate] > . . .

#45.1


Sales...
Date...
Targets...

,Term 3 of 81
You have a Power BI model that contains a table named Sales. The Sales table contains the
following columns:
• Order Line ID
• Product ID
• Unit Price
• Order ID
• Quantity
Orders are uniquely identified by using the order ID and can have multiple order lines. Each
order line within an order contains a different product ID.


You need to write a DAX measure that counts the number of orders.
Which formula should you use?

Count('Sales'[Order ID])

CountA('Sales' [Order ID])


CountRows('Sales')

DistinctCount('Sales' [Order ID])

Term 4 of 81
40.1
You have a Power BI dataset and a connected report.


You need to ensure that users can analyze data in Microsoft Excel only by connecting directly
to the dataset.You grant the users the Build permission for the dataset.
What should you do next?

Certify the dataset used by the report.

Change the default visual interaction for the report.

For the report, change the Export data setting to None.

For the report, change the Export data setting to Summarized data, data with current
layout and underlying data.

,Term 5 of 81
29.4
You have a Power BI workspace named Inventory that contains a dataset, a report, and a
dashboard.
You need to add an additional tile to the dashboard. The tile must show inventory by location.
This information is NOT visualized in the report. The solution must minimize the impact on the
report.


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


A. Ask a question by using Q&A.
B. Hide the report page.
C. Pin the visual to the dashboard.
D. Use quick insights on the dashboard.
E. Add the visual to the report.

D. Apply a transformation to extract the first 11 characters of the Logged column.


A. Publish the reports in an app and grant the HR managers access permission.

C. For the report, change the Export data setting to None.

A. Ask a question by using Q&A.
C. Pin the visual to the dashboard.

Term 6 of 81
Question #14Topic 1


You have an Azure SQL database that contains sales transactions. The database is updated
frequently.You need to generate reports from the data to detect fraudulent transactions. The
data must be visible within five minutes of an update.How should you configure the data
connection?

Add a SQL statement.

Set the Command timeout in minutes setting.

Set Data Connectivity mode to Import.

Set Data Connectivity mode to DirectQuery.

, Term 7 of 81
39.4 DRAG DROP -
You have a Power BI table named Customer that contains a field named Email Address.
You discover that multiple records contain the same email address.
You need to create a calculated column to identify which records have duplicate email
addresses.


How should you complete the DAX expression for the calculated column? To answer, drag the
appropriate values to the correct targets. 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.Select and Place:


Choose three:
ALL
CALCULATE
COUNTROWS
EVALUATE
SUM
SUMX

CALCULATE
ALEXCEPT
DIVIDE

CALCULATE
DATEADD
DIVIDE

CALCULATE
SUM
SAMEPERIODLASTYEAR

CALCULATE
COUNTROWS
ALL