Microsoft Certified: Power BI Data Analyst Associate PL-300 · Practice test

PL-300 practice exam: Power BI Data Analyst exam simulator

A timed practice exam in the PL-300 format: a 100-minute clock, flag-for-review questions, multiple-answer questions, cases from a sample company and ordering, matching and sorting questions. The questions are in English, like the real exam. The explanations and the course are in Spanish. It covers the four skill areas with the weights Microsoft publishes.

  • 📝 10 questions and tasks
  • ⏱ 15 minutes
  • 📊 Score from 100 to 900
  • 💻 Nothing to install

The questions are in English, like the real exam. The simulator interface and the answer explanations are in Spanish, because the course is taught in Spanish.

What the PL-300 exam covers

Exam facts published by Microsoft:

ItemDetail
CodePL-300 (Microsoft Certified: Power BI Data Analyst Associate)
QuestionsMicrosoft does not publish how many it has
FormatMultiple choice, case studies and interactive components
Time100 minutes
Passing score700 on a scale of 1 to 1000
LanguageAvailable in Spanish, among other languages
WhereOnline with a proctor, or at an authorized testing center

Skills measured and their weight

AreaWeight
Prepare the data25–30%
Model the data25–30%
Visualize and analyze the data25–30%
Manage and secure Power BI15–20%

PL-300 sample questions with answers

Original questions written from the public exam objectives, like the ones in the practice exam. Try to answer before opening the explanation.

  1. Question 1 · Prepare the data

    In Power Query, which percentages does the "Column quality" option show?

    • A. Valid, error and empty values
    • B. Distinct and unique values
    • C. Maximum, minimum and average
    • D. Only the values with errors
    Show the answer and explanation

    Answer: A. Valid, error and empty values

    Column quality reports what percentage of rows are valid, in error or empty. Column distribution is the one that shows distinct and unique values, and statistics such as maximum, minimum and average come from column profile.

  2. Question 2 · Model the data

    A sales measure must show the year-to-date total up to the date in context, using a marked date table. Which expression works?

    • A. TOTALYTD([Sales], Calendar[Date])
    • B. SUM(Sales[Amount])
    • C. CALCULATE([Sales], ALL(Calendar))
    • D. TOTALMTD([Sales], Calendar[Date])
    Show the answer and explanation

    Answer: A. TOTALYTD([Sales], Calendar[Date])

    TOTALYTD accumulates from the start of the year to the last date visible in the context. SUM does not change with the period, ALL(Calendar) removes the whole date filter, and TOTALMTD accumulates only within the month.

  3. Question 3 · Visualize and analyze the data

    A manager wants to see how total sales went from the January figure to the December figure, with the increase or decrease of each month. Which visual fits?

    • A. Waterfall chart
    • B. Treemap
    • C. Gauge
    • D. Scatter chart
    Show the answer and explanation

    Answer: A. Waterfall chart

    A waterfall shows how you get from a starting value to an ending one through the increases and decreases in between. A treemap compares parts of a whole, a gauge shows one value against a target, and a scatter chart relates two measures.

  4. Question 4 · Manage and secure Power BI

    A model in Import mode takes data from a SQL database on the office network. What is needed to schedule its refresh in the Power BI service?

    • A. An on-premises data gateway
    • B. Switching every table to Direct Lake
    • C. Publishing the report to "My workspace"
    • D. Adding a date parameter
    Show the answer and explanation

    Answer: A. An on-premises data gateway

    The service lives in the cloud and cannot reach a source inside the office network by itself: the on-premises data gateway is the bridge that makes scheduled refresh work. Direct Lake is for data in Fabric OneLake, and publishing to another workspace or adding a parameter does not open access to the source.

PL-300 practice test: frequently asked questions

Yes: Microsoft offers PL-300 in Spanish and in other languages. This practice exam has the questions in English, like the real exam in most languages, with the explanations in Spanish.

Microsoft does not publish how many questions it has. It lasts 100 minutes and you pass with 700 on a scale of 1 to 1000. Our practice exams have 50 questions on a 100-minute clock.

No. They are original questions written by HacksinCodigos from the public exam objectives. Real exam questions are confidential: Microsoft's rules prohibit using leaked questions ("dumps" or PDFs that claim to contain the exam), and candidates who do risk having their certification revoked and being banned from future exams. Memorized answers also won't help you with performance-based questions or on the job. Practice with original questions and read the explanation for every answer.

No. The practice exam runs in the browser. For the real exam it also helps to practice in Power BI Desktop, which is free and runs on Windows.

A good sign is finishing full practice exams on time without hints, and being able to explain why the other options are wrong. The course prepares you for the exam but does not guarantee the result.

Want the full PL-300 practice exams?

The course includes 2 full practice exams, 16 lessons with hands-on labs and a per-domain report of what to review. It is taught in Spanish, online, and you can take it from any country. US99, one payment for 12 months of access.

Message us now!