PL-300
Power BI Data Analyst PL-300 practice exams
240 questions in 5 timed practice tests. Each test has about 50 questions and a 100-minute limit. The pass mark is 70%. Results are split across the 4 exam domains.
Read the PL-300 study guide: what the exam covers, a 4-week plan and the topics people miss.
Exam at a glance
| Practice tests | 5 |
|---|---|
| Questions in total | 240 |
| Questions per test | About 50 |
| Time limit per test | 100 minutes |
| Pass mark | 70% |
| Question types | Single answer and multiple answer (22 multiple-answer questions) |
| Level | Associate |
| Category | Data & Analytics |
These are the settings of our practice tests. Check the official Microsoft exam page for the current exam format before you book.
Domains and weights
| Domain | Weight | Weight bar | Questions in our bank |
|---|---|---|---|
| Prepare the data | 28% | 67 | |
| Model the data | 27% | 64 | |
| Visualize and analyze the data | 28% | 67 | |
| Manage and secure Power BI | 17% | 42 |
Sample questions
Question 1 of 3
A Power BI Desktop file combines an Excel workbook containing customer names with a SQL Server database. When the query that filters SQL rows using values from the workbook refreshes, you receive a Formula.Firewall error stating the query references other queries or steps. Which change resolves the error while keeping data isolated appropriately?
- A Change the Excel source credentials from Windows to Anonymous so the workbook is treated as a public source
- B Disable the Allow data preview to download in the background option in the Current File data load settings page
- C Set compatible privacy levels, such as Organizational, on both sources or stage each source separately (correct answer)
- D Turn off Enable parallel loading of tables so that each query runs in sequence during the refresh
Question 2 of 3
A JSON response from a REST API loads into Power Query as a single column of Record values, and some fields contain nested lists of line items. You need one row per line item with the order fields repeated. Which sequence should you apply?
- A Convert the column to a list, then use Transpose and promote headers to turn records into columns
- B Use Parse > JSON on the record column, then pivot the line-items column using the order ID as values
- C Expand the records to columns, expand the line-items list to new rows, then expand the inner records (correct answer)
- D Use Extract Values on the line-items list with a comma delimiter, then split the column by delimiter into rows
Question 3 of 3
A report must show stock levels from an Azure SQL database that change every few seconds, and users expect values no older than one minute. The tables contain 500 million rows. Which approach is MOST appropriate?
- A Use Import mode for the stock table and configure eight scheduled refreshes in the service
- B Use Import mode for the stock table and refresh the semantic model on demand from Desktop
- C Use DirectQuery for the stock table and enable automatic page refresh on the report page (correct answer)
- D Use a live connection to the Azure SQL database and pin the page to a dashboard tile
See all 10 free PL-300 questions with answers Read them or quiz yourself.
What your score report looks like
Example attempt, PL-300 practice test 3
78%
Passed
Pass mark 70%
| Domain | Weight | Your score | % |
|---|---|---|---|
| Prepare the data | 28% | 88 | |
| Model the data | 27% | 81 | |
| Visualize and analyze the data | 28% | 76 | |
| Manage and secure Power BI | 17% | 58 |
Study next: Manage and secure Power BI. It is below the pass mark and carries 17% of the exam.
Study plans
Two weeks
- Day 1: take practice test 1 in exam mode to get a baseline.
- Days 2 to 5: domain mode on Prepare the data and Visualize and analyze the data, the two most heavily weighted domains.
- Day 6: practice test 2 in exam mode, then the mistakes quiz.
- Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
- Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.
Four weeks
- Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
- Week 2: domain mode on those two domains, then a second practice test in exam mode.
- Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
- Week 4: practice test 5 and final mode until your readiness holds above the pass mark.
Questions about the PL-300 practice exams
- Are these real PL-300 exam questions?
- No. We write every question ourselves and map it to the published PL-300 exam objectives. We do not use leaked or recalled questions.
- Do the time limit and pass mark match the official exam?
- They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.
- Can I try it before I pay?
- Yes. The free mini exam has 15 questions with full explanations and needs no account.
- How long do I keep access?
- A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.
- What happens after I finish a test?
- You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.
Related exams
| Exam | Vendor | Level | Questions | Minutes | Price |
|---|---|---|---|---|---|
| AB-100AB-100 Agentic AI Business Solutions Architect | Microsoft | Professional | 250 | 100 | $14.99 |
| AB-730AI Business Professional AB-730 | Microsoft | Professional | 250 | 100 | $14.99 |
| AZ-305Azure Solutions Architect AZ-305 | Microsoft | Professional | 250 | 100 | $14.99 |
| SC-100Cybersecurity Architect SC-100 | Microsoft | Professional | 250 | 120 | $14.99 |
| AZ-140Azure Virtual Desktop AZ-140 | Microsoft | Specialty | 251 | 100 | $14.99 |
| DP-420Microsoft DP-420 | Microsoft | Specialty | 250 | 100 | $14.99 |