PL-300 Practice Test 34 — 15 Questions

Question 1

You have a Power BI report that uses a composite model with a DirectQuery source (SQL Server) and a local imported table. The report includes a measure that calculates sales growth by comparing current year to previous year. Users report that the measure returns blank for months with no data in the current year. How should you modify the measure to show 0% growth instead of blank?

Accepted Answer

Use COALESCE(CurrentYear, 0) in the measure.. Option B is correct because COALESCE replaces blank with the next non-blank value, so if CurrentYear is blank but PreviousYear has data, it returns 0. Option A is wrong because ISBLANK would still return blank if CurrentYear is blank. Option C is wrong because it only handles division by zero. Option D is wrong because it replaces blank with 0 only for the denominator.

Answer

Use ISBLANK(CurrentYear) in an IF statement.

Answer

Add a condition to check if PreviousYear = 0.

Answer

Use DIVIDE with an alternate result of 0.

Question 2

Which TWO of the following are valid ways to share a Power BI report with external users who do not have a Power BI license?

Accepted Answer

Embed in a secure portal using Power BI Embedded. Publish to web makes the report public (no license needed). Embed in a secure portal (using Power BI Embedded) also allows external access without licenses if capacity is used.

Answer

Export to PDF and email

Answer

Share via Power BI service with a direct link

Answer

Create a Power BI app and grant access

Question 3

You have a Power BI report that uses a date hierarchy (Year, Quarter, Month) on the axis of a line chart. Users want to drill down from year to quarter to month. However, the drill-down feature is not working. What is the most likely cause?

Accepted Answer

The date field is placed in the Axis field well without creating a hierarchy.. Option C is correct because the drill-down feature requires a hierarchy in the field well. If only the date field is used without explicit hierarchy, drill-down is disabled. Option A is wrong because the line chart supports drill-down with hierarchies. Option B is wrong because cross-filtering does not disable drill-down. Option D is wrong because drill-down does not require a date table relationship.

Answer

The line chart does not support drill-down functionality.

Answer

The date table is not marked as a date table in the model.

Answer

Cross-filtering from another visual is interfering.

Question 4

You are designing a Power BI report for executive leadership. The report must display key performance indicators (KPIs) with current values and trend arrows. Which visual type should you use?

Accepted Answer

KPI visual. Option C is correct because the KPI visual is specifically designed to show a current value, a status indicator (like trend arrow), and a goal. Option A is wrong because a card visual only shows a single value without trend. Option B is wrong because a gauge visual shows progress toward a goal but not a trend arrow. Option D is wrong because a table visual is for detailed data, not KPIs.

Answer

Table visual

Answer

Card visual

Answer

Gauge visual

Question 5

You have a Power BI report that includes a line chart showing monthly sales. You want to add a trend line to help users identify the overall direction of sales over time. Which feature should you use?

Accepted Answer

Analytics pane in the visual. Option A is correct because the Analytics pane in line chart visuals provides the 'Trend line' option. Option B is wrong because a forecast is different from a trend line. Option C is wrong because the format pane deals with visual appearance, not analytics. Option D is wrong because DAX is not required to add a trend line.

Answer

Forecast option in the visual

Answer

Add a DAX measure for linear regression

Answer

Format pane to change line style

Question 6

You are designing a report for mobile users. Which layout consideration is most important to ensure usability on small screens?

Accepted Answer

Use a vertical layout with key metrics placed at the top.. Option C is correct because mobile reports should have a vertical layout with key metrics at the top to avoid scrolling. Option A is wrong because horizontal scrolling is difficult on mobile. Option B is wrong because many visuals do not support tooltips on mobile. Option D is wrong because a single page with all visuals is overwhelming on mobile.

Answer

Arrange visuals horizontally to use screen width.

Answer

Place all visuals on a single page to avoid page navigation.

Answer

Use tooltips to provide additional details on tap.

Question 7

You want to create a Power BI report that allows users to ask questions in natural language and get visual answers. Which feature should you enable?

Accepted Answer

Q&A visual. Option C is correct because Q&A (natural language query) allows users to ask questions. Option A is wrong because Copilot is for AI assistance, but not specifically for natural language queries in reports. Option B is wrong because Key influencers is a visual for analysis. Option D is wrong because Decomposition tree is for hierarchical drill-down.

Answer

Key influencers visual

Answer

Copilot for Power BI

Answer

Decomposition tree

Question 8

You have a Power BI report that uses a calculated column to categorize sales as 'High', 'Medium', or 'Low'. You notice the column is not being refreshed when the underlying data changes. What is the most likely reason?

Accepted Answer

Calculated columns are only refreshed when the dataset is refreshed.. Option C is correct because calculated columns are computed during data refresh and are static until the next refresh. Option A is wrong because changes to data do not trigger recalculation of calculated columns. Option B is wrong because the column is not a measure. Option D is wrong because the column is correctly defined.

Answer

The column is defined as a measure instead of a calculated column.

Answer

The DAX syntax for the calculated column is incorrect.

Answer

The calculated column uses a function that does not support dynamic updates.

Question 9

Your Power BI report uses a calculated table to create a date dimension. You need to add a column that shows the fiscal quarter based on a fiscal year starting in July. What DAX expression should you use?

Accepted Answer

Fiscal Quarter = "Q" & FORMAT('Date'[Date], "Q", "en-US", 2025-07-01). Option A is correct because FORMAT with "Q" returns the quarter number, and the shift of 0 accounts for the fiscal year start in July (July=Q1). Option B is wrong because it returns the calendar quarter. Option C is wrong because it uses "\QQ" which is incorrect syntax. Option D is wrong because it uses QUARTER function which returns calendar quarter.

Answer

Fiscal Quarter = "Q" & FORMAT('Date'[Date], "\QQ")

Answer

Fiscal Quarter = "Q" & FORMAT('Date'[Date], "Q")

Answer

Fiscal Quarter = "Q" & QUARTER('Date'[Date])

Question 10

You need to create a Power BI report that allows users to analyze sales data by multiple dimensions including date, product, and region. Which THREE features should you use to provide a good user experience?

Accepted Answer

Add slicers for date, product, and region.. Options A, C, and E are correct. A: Slicers allow users to filter data interactively. C: Drill-through enables navigation to detail pages. E: Bookmarks can save and switch between views. Option B is wrong because disabling cross-filtering limits interactivity. Option D is wrong because tooltips are for additional info, not primary navigation.

Answer

Disable cross-filtering between visuals.

Answer

Use only default tooltips.

Question 11

You create a report that uses an AI visual to find key influencers. Which type of field can the AI visual analyze as the 'analyze' field?

Accepted Answer

A numeric field such as sales amount. The Key Influencers visual analyzes a numeric field (measure or column) to determine what influences its value.

Answer

A date field

Answer

A binary Yes/No field

Answer

A categorical text field

Question 12

You have a Power BI report with a matrix that shows sales by region and product category. Users complain that the matrix is too cluttered and hard to read. Which best practice should you apply to improve readability?

Accepted Answer

Apply conditional formatting using data bars or color scales.. Option C is correct because applying conditional formatting with data bars or color scales helps users quickly identify patterns without adding clutter. Option A is wrong because adding more hierarchy levels increases complexity. Option B is wrong because removing totals reduces context. Option D is wrong because changing to a table with all details would not reduce clutter.

Answer

Remove all subtotals and grand totals.

Answer

Add more hierarchy levels to the rows to provide granularity.

Answer

Change the matrix to a table with all detail rows.

Question 13

You have a Power BI report that uses a composite model with a DirectQuery source from Azure SQL Database and an imported table from Excel. You need to ensure that when a user filters the imported table, the DirectQuery table is also filtered accordingly. What should you configure?

Accepted Answer

Set the relationship direction to filter the DirectQuery table from the imported table.. Option D is correct because setting a relationship between the DirectQuery table and the imported table, with the imported table as the filter direction, allows filtering across storage modes. Option A is wrong because a calculated column in the DirectQuery table would not automatically filter based on the imported table. Option B is wrong because enabling bidirectional cross-filtering on relationships between DirectQuery and imported tables is not supported in composite models. Option C is wrong because merging tables would change the data model and may not be necessary.

Answer

Merge the imported table into the DirectQuery source.

Answer

Enable bidirectional cross-filtering on the relationship between the tables.

Answer

Create a calculated column in the DirectQuery table that references the imported table.

Question 14

You want to allow users to filter a report by a specific date range (e.g., last 30 days) without requiring manual selection. Which approach should you take?

Accepted Answer

Add a relative date slicer to the report page.. Option A is correct because a relative date slicer allows users to choose predefined periods like last 30 days. Option B is wrong because a filter pane applies to all pages but is not interactive. Option C is wrong because a calculated column would require maintenance. Option D is wrong because bookmarks capture a specific view, not dynamic range.

Answer

Use bookmarks to switch between fixed date ranges.

Answer

Create a calculated column that flags rows within the last 30 days.

Answer

Apply a filter on the date field in the Filters pane.

Question 15

You have a Power BI dataset that contains a table with sales data and a separate date table. You create a measure that uses CALCULATE and DATESYTD to show year-to-date sales. The measure returns incorrect values for the first month of the year. What is the most likely cause?

Accepted Answer

The date table does not contain a continuous range of dates for the entire year.. Option D is correct because DATESYTD requires a continuous date range; if the date table does not include all dates, the YTD calculation may be incomplete. Option A is wrong because DATESYTD does not require marking as date table. Option B is wrong because relationship direction is not the issue. Option C is wrong because month granularity is not the problem.

Answer

The relationship between tables is single-directional.

Answer

The date table uses month granularity instead of day.

Answer

The date table is not marked as a date table.