# Power BI Data Analyst PL-300 practice exams

> Prepare for PL-300 with 240 practice questions across 5 full timed exams, weighted toward Prepare the data. Every answer is explained.

Page: https://devopscodelab.com/exams/microsoft-pl-300/

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.

## Exam at a glance

| Setting | Value |
| --- | --- |
| 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 format before you book.

## Domains and weights

| Domain | Weight | 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 |

## Price and access

- PL-300 practice exams: $12.99 for 12 months of access.
- Free mini exam: 15 questions with explanations (free account): https://devopscodelab.com/app/exams/microsoft-pl-300/mini/
- All-Access subscription includes every exam: https://devopscodelab.com/pricing/
- 10 free questions with answers: https://devopscodelab.com/exams/microsoft-pl-300/free-practice-questions/

## 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
- D. Turn off Enable parallel loading of tables so that each query runs in sequence during the refresh

**Answer:** C

**Explanation:** The Formula.Firewall error is raised by the privacy-level engine when one source's data could be folded into another; assigning compatible privacy levels or splitting the access into separate queries removes the conflict. Background preview download only affects the editor experience. Changing credentials to Anonymous does not set a privacy level and would usually fail authentication. Parallel loading controls concurrency and has no effect on data-combination rules.

### 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
- D. Use Extract Values on the line-items list with a comma delimiter, then split the column by delimiter into rows

**Answer:** C

**Explanation:** Records expand into columns and lists expand to new rows, so expanding the record, then the list, then the inner records yields one row per line item with order fields repeated. Parse JSON is for text that holds JSON, not values that are already records, and pivoting would aggregate rather than flatten. Transposing a list of records does not flatten nested lists. Extract Values concatenates list items as text, losing the structure of each line item.

### 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
- D. Use a live connection to the Azure SQL database and pin the page to a dashboard tile

**Answer:** C

**Explanation:** DirectQuery queries the source at view time and automatic page refresh can update visuals every minute, meeting the freshness need without importing 500 million rows. Eight scheduled refreshes give hours-old data and a very large import. On-demand refreshes from Desktop are manual and impractical. Live connections apply to Analysis Services and Power BI semantic models, not Azure SQL Database, and dashboard tiles do not change the data freshness.


## Study plans

### Two weeks

1. Day 1: take practice test 1 in exam mode to get a baseline.
2. Days 2 to 5: domain mode on Prepare the data and Visualize and analyze the data, the two most heavily weighted domains.
3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

### Four weeks

1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
4. 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.

Last updated November 2026.

DevOpsCode Lab is not affiliated with Microsoft. PL-300 and related names are trademarks of their owners. We write every question ourselves; these are not real exam questions.
