PL-300

Free PL-300 practice questions

10 questions from our PL-300 practice tests, each with the correct answer and a written explanation. Read them with the answers shown, or switch to quiz mode and answer first.

Back to the PL-300 practice exams

Question 1 of 10, Prepare the data

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?

  1. AChange the Excel source credentials from Windows to Anonymous so the workbook is treated as a public source
  2. BDisable the Allow data preview to download in the background option in the Current File data load settings page
  3. CSet compatible privacy levels, such as Organizational, on both sources or stage each source separately Correct answer
  4. DTurn off Enable parallel loading of tables so that each query runs in sequence during the refresh

Answer and 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, Prepare the data

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?

  1. AConvert the column to a list, then use Transpose and promote headers to turn records into columns
  2. BUse Parse > JSON on the record column, then pivot the line-items column using the order ID as values
  3. CExpand the records to columns, expand the line-items list to new rows, then expand the inner records Correct answer
  4. DUse Extract Values on the line-items list with a comma delimiter, then split the column by delimiter into rows

Answer and 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, Prepare the data

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?

  1. AUse Import mode for the stock table and configure eight scheduled refreshes in the service
  2. BUse Import mode for the stock table and refresh the semantic model on demand from Desktop
  3. CUse DirectQuery for the stock table and enable automatic page refresh on the report page Correct answer
  4. DUse a live connection to the Azure SQL database and pin the page to a dashboard tile

Answer and 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, Model the data

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?

  1. ACALCULATE([Sales Amount], CROSSFILTER(Sales[ShipDate], 'Date'[Date], Both))
  2. BCALCULATE([Sales Amount], USERELATIONSHIP(Sales[ShipDate], 'Date'[Date])) Correct answer
  3. CCALCULATE([Sales Amount], RELATED('Date'[Date]) = Sales[ShipDate])
  4. DCALCULATE([Sales Amount], TREATAS(VALUES(Sales[ShipDate]), 'Date'[Date]))

Answer and 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, Model the data

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?

  1. ARelate both dimensions one-to-many to Enrolment; make Student-Enrolment filter in both directions Correct answer
  2. BMerge Course into Student in Power Query so every student row lists a semicolon-separated set of courses
  3. CCreate a direct many-to-many relationship between Student and Course using a shared Name column
  4. DRelate both dimensions one-to-many to Enrolment with single direction and use a calculated column for counts

Answer and 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, Model the data

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?

  1. AAVERAGEX(VALUES('Date'[Date]), CALCULATE(SUM(Inventory[Quantity])))
  2. BCALCULATE(SUM(Inventory[Quantity]), FILTER(ALL('Date'), 'Date'[Date] = MAX('Date'[Date])))
  3. CCALCULATE(SUM(Inventory[Quantity]), LASTNONBLANK('Date'[Date], CALCULATE(COUNTROWS(Inventory)))) Correct answer
  4. DCALCULATE(MAX(Inventory[Quantity]), DATESMTD('Date'[Date]))

Answer and 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, Visualize and analyze the data

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?

  1. AA Power BI report exported to PowerPoint as images with the Include hidden report pages option enabled
  2. BA Power BI report page with a table visual and Export to PDF enabled on the page
  3. CA dashboard with a pinned table tile and a weekly email subscription to the dashboard
  4. DA paginated report published to the Power BI service with a subscription delivering PDF Correct answer

Answer and 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, Visualize and analyze the data

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?

  1. AWaterfall chart
  2. BClustered column chart with a constant line
  3. CLine and clustered column chart Correct answer
  4. DStacked area chart with a target series

Answer and 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, Visualize and analyze the data

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?

  1. AAdd the trend chart fields to the map's Tooltips well and enable Show data labels on the map visual
  2. BCreate a drillthrough page using Country as the field and set the map's tooltip type to Default to display that page
  3. CCreate a bookmark of a page with the trend chart, then assign the bookmark to the map's tooltip action
  4. DBuild a page with Allow use as tooltip on, add the visuals, and select it as the map's report page tooltip Correct answer

Answer and 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, Manage and secure Power BI. Choose 2.

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

  1. ARLS roles must be defined in the service because Desktop cannot define them
  2. BRLS is enforced for users with the Viewer role in the workspace Correct answer
  3. CMicrosoft Entra security groups can be added as members of an RLS role Correct answer
  4. DRLS can hide specific tables and columns from users in a role
  5. ERLS is enforced for workspace Admins, Members and Contributors

Answer and 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.