Exam (elaborations)
PL-300 MICROSOFT POWER BI DATA ANALYST QUESTIONS AND ANSWERS
- Course
- Institution
PL-300 MICROSOFT POWER BI DATA ANALYST QUESTIONS AND ANSWERS
[Show more]
Content preview
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller selftest. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.00. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77254 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now