# Free PL-300 practice questions

> 10 free PL-300 practice questions with the correct answer and an explanation.

Page: https://devopscodelab.com/exams/microsoft-pl-300/free-practice-questions/
Practice exams: https://devopscodelab.com/exams/microsoft-pl-300/

### Question 1 of 10

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 10

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 10

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.

### Question 4 of 10

The Sales table has OrderDate, ShipDate and DueDate columns, all relating to one Date table. Only the OrderDate relationship is active. You need a measure that returns sales amount by ship date without changing the model. Which DAX should you use?

- A. CALCULATE([Sales Amount], CROSSFILTER(Sales[ShipDate], 'Date'[Date], Both))
- B. CALCULATE([Sales Amount], USERELATIONSHIP(Sales[ShipDate], 'Date'[Date]))
- C. CALCULATE([Sales Amount], RELATED('Date'[Date]) = Sales[ShipDate])
- D. CALCULATE([Sales Amount], TREATAS(VALUES(Sales[ShipDate]), 'Date'[Date]))

**Answer:** B

**Explanation:** USERELATIONSHIP activates the inactive ShipDate relationship for the duration of the CALCULATE, which is the standard role-playing dimension pattern. CROSSFILTER changes filter direction of an existing relationship but does not activate an inactive one. The TREATAS expression applies Sales ship dates as a filter on Date, which is backwards and does not filter Sales by the selected date. RELATED cannot be used as a filter argument in this way and the expression is invalid.

### Question 5 of 10

Students can enrol in many courses and each course has many students. The model contains Student, Course and an Enrolment table with StudentID and CourseID. A Course slicer must filter a Student count measure. How should you configure the relationships?

- A. Relate both dimensions one-to-many to Enrolment; make Student-Enrolment filter in both directions
- B. Merge Course into Student in Power Query so every student row lists a semicolon-separated set of courses
- C. Create a direct many-to-many relationship between Student and Course using a shared Name column
- D. Relate both dimensions one-to-many to Enrolment with single direction and use a calculated column for counts

**Answer:** A

**Explanation:** Enrolment acts as a bridge; with one-to-many relationships to both dimensions and bi-directional filtering from Enrolment to Student, a course selection propagates to the students enrolled. A direct many-to-many relationship on a shared name column is unreliable and has no meaningful key. With single direction, Course filters Enrolment but not Student, and a calculated column cannot respond to slicers. Concatenating courses into text prevents filtering.

### Question 6 of 10

An Inventory table stores one row per product per day with the quantity on hand. Users report that the Stock measure, defined as SUM(Inventory[Quantity]), shows a monthly total that is about 30 times larger than expected. You need the month value to show the closing stock on the last date with data in that month. Which measure should you create?

- A. AVERAGEX(VALUES('Date'[Date]), CALCULATE(SUM(Inventory[Quantity])))
- B. CALCULATE(SUM(Inventory[Quantity]), FILTER(ALL('Date'), 'Date'[Date] = MAX('Date'[Date])))
- C. CALCULATE(SUM(Inventory[Quantity]), LASTNONBLANK('Date'[Date], CALCULATE(COUNTROWS(Inventory))))
- D. CALCULATE(MAX(Inventory[Quantity]), DATESMTD('Date'[Date]))

**Answer:** C

**Explanation:** Stock balances are semi-additive: they sum across products but not across time, so the measure must take the last date that actually has inventory rows, which LASTNONBLANK with a row-count expression returns. Filtering ALL('Date') to the maximum date picks the last calendar day of the month, which returns blank when no snapshot exists for that day. AVERAGEX over dates returns the average daily stock, not the closing balance. MAX of quantity returns the largest single product row in the month, not the total closing stock.

### Question 7 of 10

A report must let users print a 40-page, pixel-perfect invoice list with headers repeated on each page and every row of a large table rendered, exported to PDF each week. What should you recommend?

- A. A Power BI report exported to PowerPoint as images with the Include hidden report pages option enabled
- B. A Power BI report page with a table visual and Export to PDF enabled on the page
- C. A dashboard with a pinned table tile and a weekly email subscription to the dashboard
- D. A paginated report published to the Power BI service with a subscription delivering PDF

**Answer:** D

**Explanation:** Paginated reports are designed for print-ready, multi-page output that renders all rows with repeating headers, and subscriptions can deliver them as PDF. Exporting a Power BI report page to PDF only captures what is visible in each visual, so a long table would be truncated. A dashboard tile shows a snapshot of a visual, not paged output. PowerPoint export also captures images of pages and does not paginate a large table.

### Question 8 of 10

A manager wants to compare monthly revenue against a monthly target in one visual, with revenue as columns and the target as a line on the same axis. Which visual should you use?

- A. Waterfall chart
- B. Clustered column chart with a constant line
- C. Line and clustered column chart
- D. Stacked area chart with a target series

**Answer:** C

**Explanation:** The line and clustered column combo chart shows one measure as columns and another as a line over a shared category axis. A constant line from the Analytics pane is a single fixed value, so it cannot follow a target that changes each month. A stacked area chart would add the target on top of revenue, misrepresenting both values. A waterfall chart shows how values add or subtract from a starting total.

### Question 9 of 10

You want a report tooltip that shows a small trend chart and the top three products whenever a user hovers over a country in a map visual. What should you do?

- A. Add the trend chart fields to the map's Tooltips well and enable Show data labels on the map visual
- B. Create a drillthrough page using Country as the field and set the map's tooltip type to Default to display that page
- C. Create a bookmark of a page with the trend chart, then assign the bookmark to the map's tooltip action
- D. Build a page with Allow use as tooltip on, add the visuals, and select it as the map's report page tooltip

**Answer:** D

**Explanation:** Report page tooltips are built on a page marked Allow use as tooltip and then assigned to a visual in its Tooltip formatting options, so hovering renders that page. Fields in the Tooltips well only add values as text, not charts. Bookmarks cannot be assigned as tooltips. Drillthrough pages open on right-click navigation; the Default tooltip type shows the standard text tooltip, not a page.

### Question 10 of 10 (choose 2)

Which two statements about row-level security in the Power BI service are correct? (Choose two.)

- A. RLS roles must be defined in the service because Desktop cannot define them
- B. RLS is enforced for users with the Viewer role in the workspace
- C. Microsoft Entra security groups can be added as members of an RLS role
- D. RLS can hide specific tables and columns from users in a role
- E. RLS is enforced for workspace Admins, Members and Contributors

**Answer:** B, C

**Explanation:** RLS filters apply to Viewers and to users who access content through apps or sharing, and roles can contain security groups. Admins, Members and Contributors have edit rights and are not restricted by RLS. Roles are defined in Desktop or the service's data model editing but membership is managed in the service. Hiding tables and columns is object-level security, not RLS.

Ready for a timed run? Take the free 15-question PL-300 mini exam: https://devopscodelab.com/app/exams/microsoft-pl-300/mini/

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.
