Free practice test · no sign-up
PL-300Free Microsoft Power BI Data Analyst practice test
- ✓ 10 free questions
- ✓ Instant answers & explanations
- ✓ No sign-up, no email
10 real PL-300 practice questions with instant answers and explanations — no account, no credit card, no email. Score yourself, then unlock the full bank of 70 questions whenever you’re ready. The PL-300 passing score is 700 / 1000.
A team loads a sales table into Power BI using Import storage mode. Which statement best describes what happens to the data?
Answer key
All 10 PL-300 questions & answers
Prefer to just read the answers and explanations? Here’s the full key for this free PL-300 test.
Q1. A team loads a sales table into Power BI using Import storage mode. Which statement best describes what happens to the data?
Correct answer: A. A snapshot of the data is copied into the model and compressed in memory, so a refresh is needed to see new source rows
Import mode copies and compresses a point-in-time snapshot of the data into the model, so a dataset refresh is required for the report to reflect newer source rows.
Q2. In Power Query, why is it beneficial when the applied steps of a query 'fold' back to the source?
Correct answer: A. The transformations are translated into a single native source query, so the source engine does the work and less data is transferred
Query folding pushes transformation logic down into a native query executed by the source, reducing data movement and improving refresh performance.
Q3. You have two tables with identical columns—one holding January orders and one holding February orders—and you want a single table containing all rows from both. Which Power Query operation should you use?
Correct answer: A. Append queries
Append stacks rows from tables with the same column shape into one combined table, which is exactly what combining two months of orders requires.
Q4. A query named Sales feeds several downstream queries. You create a new query using Reference on Sales instead of Duplicate. What is the practical difference?
Correct answer: A. A referenced query points to the output of the source query, so source changes flow through, while a duplicate is an independent copy of the steps
Reference builds on the live output of the base query so changes propagate downstream, whereas Duplicate creates a standalone copy of the step logic.
Q5. A model built on a Microsoft Fabric lakehouse uses Direct Lake storage mode. Which characteristic distinguishes Direct Lake from both Import and DirectQuery?
Correct answer: A. It reads Delta/Parquet files directly from OneLake without importing data or translating queries to a source database, giving near-import speed with no scheduled copy
Direct Lake loads columnar Delta/Parquet data straight from OneLake into memory on demand, combining import-like performance with no separate data-copy step.
Q6. A spreadsheet has one column per month (Jan, Feb, Mar …) with sales values across each row. To make it suitable for a star-schema fact table, you want a single Month column and a single Value column. Which transformation accomplishes this?
Correct answer: A. Unpivot Columns
Unpivot turns wide, column-per-category data into a narrow attribute/value pair layout, which is the normalized shape fact tables need.
Q7. A customer dimension query accidentally contains the same CustomerID on multiple rows. Which Power Query action keeps only one row per CustomerID?
Correct answer: A. Select the CustomerID column and use Remove Duplicates
Selecting the key column and choosing Remove Duplicates retains only the first occurrence of each CustomerID, producing a clean dimension.
Q8. After changing a column's data type, several rows now show Error because they contain non-numeric text. You want to keep those rows but blank out the bad values. What is the best approach?
Correct answer: A. Use Replace Errors to substitute the error cells with null or another value
Replace Errors swaps error cells for a chosen value such as null while preserving the rows, unlike Remove Errors, which drops them entirely.
Q9. Before cleaning a dataset you enable Column quality in Power Query. What information does this feature surface for each column?
Correct answer: A. The percentage of values that are valid, in error, and empty
Column quality profiles each column into valid, error, and empty percentages so you can spot data issues before loading.
Q10. Why should you explicitly set the correct data type for each column in Power Query before loading?
Correct answer: A. Correct types ensure accurate aggregation, sorting, and relationships and prevent DAX errors later
Accurate data types drive correct aggregation, sorting, relationship matching, and downstream DAX behavior, so they should be set during data prep.
Exam facts and objectives sourced from the official Microsoft certification page. Last reviewed June 2026.
Ready for the full PL-300 bank? Start free.
70 questions, timed mock exams, and missed-question review — 30 free questions, no card.
Start free trial