PL-300 Microsoft · Data Analyst

PL-300 practice test

Microsoft Power BI Data Analyst. Practice exam aligned to the PL-300 skills measured (April 2026): preparing data with Power Query, modeling data with DAX, visualizing and analyzing data, and managing and securing Power BI.

  • 9 practice tests + challenge test
  • 500 questions
  • 40 questions, 90 min per test
  • Pass at 70%

Take the free PL-300 diagnostic10 questions, no card needed

Free PL-300 sample questions

3 questions from the free diagnostic, with answers and explanations.

Question 1 · Get or connect to data

Which Power BI storage mode copies the source data into the semantic model and usually gives the fastest report interactions?

  1. Import
  2. DirectQuery
  3. Live connection
  4. Dual with no cached data
Show answer

Answer: A (Import)

Import loads a compressed copy of the data into the model, so visuals query in-memory data. DirectQuery and live connections query the source each time.

Question 2 · Transform and load the data

A budget table has a Product column and then one column per month (Jan, Feb ... Dec). You need a Month column and an Amount column so the table can relate to a Date table. Which Power Query transformation should you use?

  1. Select the month columns and use Unpivot Columns
  2. Select Product and use Unpivot Columns
  3. Select the month columns and use Pivot Column
  4. Transpose, then use the first row as headers
Show answer

Answer: A (Select the month columns and use Unpivot Columns)

Unpivoting turns the month columns into attribute and value rows: one row per product and month.

Question 3 · Create reports

Which visual best shows how monthly revenue changed over the last 24 months?

  1. Line chart
  2. Funnel chart
  3. Waterfall chart
  4. Treemap
Show answer

Answer: A (Line chart)

A line chart shows a trend over a continuous time axis.

Try the full diagnostic free

What the PL-300 practice covers

Share of practice questions per skill area.

  • Create model calculations by using DAX14%
  • Design and implement a data model12%
  • Create reports12%
  • Transform and load the data12%
  • Enhance reports for usability and storytelling11%
  • Create and manage workspaces and assets10%
  • Get or connect to data8%
  • Profile and clean the data8%
  • Identify patterns and trends6%
  • Secure and govern Power BI items5%
  • Optimize model performance3%

Question formats

  • Single choice
  • Multiple select
  • Hotspot (drop-down and yes/no)
  • Drag-and-drop matching
  • Drag-and-drop select and place
  • Case studies
  • Exhibits (screenshots, diagrams and code)

Career path: Data Analyst

Prepare data, build semantic models and design reports in Power BI.

  1. DP-900
  2. PL-300

Guides

PL-300 practice test FAQ

Is there a free PL-300 practice test?

Yes. Create a free account and take the PL-300 free diagnostic: 10 questions across every skill area of the exam, with a study plan for the topics to work on. You can retake it as often as you like.

How many questions are in each ExamKite PL-300 practice test?

Each full practice test has 40 questions with a 90-minute timer, and you pass at 70%. There are 9 practice tests plus a harder challenge test, with 500 questions in total.

Which question formats does the PL-300 practice include?

Single choice, multiple select, hotspot (drop-down and yes/no), drag-and-drop matching, drag-and-drop select and place, case studies and exhibits (screenshots, diagrams and code), the same formats you meet on the real exam.

Are these real PL-300 exam questions?

No. They are original questions written for ExamKite and mapped to the Microsoft skills outline, never copied from the real exam. Using leaked exam questions breaks the certification provider's exam rules and can get your certification revoked.

More answers in the full FAQ.

Ready to practice for PL-300?

Start with the free diagnostic and get a study plan for the topics you miss.

Create a free account