Power BI Data Analyst (PL-300) Readiness Test

10 questions, balanced across the exam's topics. Answer each one, then submit for your practice readiness estimate and per-topic breakdown. This is a practice estimate — not a prediction or guarantee of your official exam result.

Question 1

Pivoting without aggregation fails because the same Region-Metric pair appears twice. What must be resolved?

Change only the output column order Disable load so the pivot can ignore duplicate intersections Increase the preview limit while preserving duplicate pivot intersections Define an appropriate aggregation or correct the duplicate grain

Question 2

An analyst wants a selected numeric column's statistics and value distribution together. Which feature should be enabled?

Column distribution alone Column profile Column quality alone Query Dependencies

Question 3

A finance team needs repeatable access to rows in SQL Server, rather than a monthly spreadsheet export. Which connector is most appropriate?

SharePoint folder Text/CSV Excel workbook SQL Server database

Question 4

When evaluating DirectQuery feasibility, which source characteristic matters most?

Its ability to accept any nonfolding M transformation as a native query Its ability to retain credentials only in a local workbook Its ability to export a monthly file while refusing interactive queries Its ability to answer the report's queries with acceptable latency

Question 5

A thin report contains no local imported tables. Where is the shared data model ordinarily maintained?

In the connected semantic model In a separate Power Query cache embedded in every report page In the report's page-navigation definitions In each visual as a complete copy of the relationship diagram

Question 6

Which join returns left-table rows with no match in the right table?

Right outer Inner Left anti Full outer

Question 7

A category rule says amounts of exactly 100 qualify for the premium tier. Which comparison implements the boundary?

[Amount] > 100 [Amount] <> 100 [Amount] >= 100 [Amount] < 100

Question 8

Why should transaction counts distinguish rows from distinct orders in a line-level fact?

Order identifiers must never repeat Distinct counts always equal sums One order can contribute multiple rows Every row is guaranteed to be a separate customer

Question 9

Which identifier combination can uniquely identify an order-line fact when line numbers restart for each order?

LineNumber alone ProductCategory alone OrderMonth alone OrderID and LineNumber

Question 10

A supported SQL source must retain detailed data, and reports should query current source values without importing all rows. Which mode is the natural starting point?

A static exported PDF DirectQuery Enter data Import with no refresh

Unanswered questions count as incorrect. Your answers are graded on the server; no answer key is sent to your browser.

← Back to the Power BI Data Analyst (PL-300) page

About Contact Privacy Policy Terms of Service Refund Policy

Home Exams Simulations WorkTrials GameScope Account