PL-300 Visualize and analyze the data Practice Test 3 — 15 Questions

Question 1

Refer to the exhibit. You have a DAX measure that ranks products by sales amount. When you add this measure to a table visual with ProductID and Sales Amount, you notice that the rank resets for each year when you add a Year slicer. What should you modify to ensure ranking is always across all products regardless of slicer?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Change ALL to ALL(Sales) and add a filter to ignore year. The correct option is C: change ALL to ALL(Sales) and add a filter to ignore year. In DAX, ALL(Sales) removes all filters from the Sales table, including the Year slicer, so the rank measure evaluates across all products and all years rather than resetting per year. Adding a filter to ignore year ensures the slicer does not reapply the year context to the ranking calculation. Option A, ALLSELECTED(Sales[ProductID]), only removes filters on ProductID while respecting the Year slicer, so the rank would still reset by year. Option B, ALLEXCEPT(Sales, Sales[Year]), keeps the Year filter active, which also causes the rank to reset per year. Option D, VALUES(Sales[ProductID]), does not remove filters and would not produce a global rank across all products.

Answer

Change ALL to ALLSELECTED(Sales[ProductID])

Answer

Change ALL to ALLEXCEPT(Sales, Sales[Year])

Answer

Change ALL to VALUES(Sales[ProductID])

Question 2

You have a Power BI report that uses a live connection to an Azure Analysis Services (AAS) model. Users report that the report takes a long time to load when they apply a slicer on a calculated column. What should you recommend?

Accepted Answer

Convert the calculated column to a measure if the logic allows. The correct option is B: convert the calculated column to a measure if the logic allows. Calculated columns are materialized and processed at refresh time, and in a live-connected AAS model a slicer on a calculated column forces the engine to scan and aggregate that column at query time, which is slow; measures are evaluated dynamically at query time using the formula engine and can leverage aggregation and caching, so replacing the column with a measure (when the logic permits) removes the costly column scan and improves slicer responsiveness. Option A does not fit because a calculated table is also materialized and would not address the per-query slicer cost, and it changes the model structure unnecessarily. Option C is invalid because incremental refresh applies to tables/partitions, not to calculated columns, and cannot be configured on a column. Option D is irrelevant because disabling cross-filtering does not reduce the cost of evaluating the calculated column used by the slicer.

Answer

Replace the calculated column with a calculated table

Answer

Implement incremental refresh on the calculated column

Answer

Disable cross-filtering between the slicer and the visual

Question 3

You have a Power BI report that uses Import mode. The dataset is refreshed daily. Users are complaining that the report shows data from yesterday morning even though the refresh completed successfully at 2:00 AM today. What should you check first?

Accepted Answer

Examine the incremental refresh policy's rangeStart and rangeEnd parameters. The correct option is D: examine the incremental refresh policy's rangeStart and rangeEnd parameters. With incremental refresh, only partitions within the configured time range are refreshed, so if rangeStart/rangeEnd are misconfigured or the range doesn't cover the latest data, the report can keep showing older data even though the refresh job completed successfully. The other options do not fit: A (RLS role assignments) affects which rows users can see, not data recency; B (refresh history errors) is less relevant because the refresh already completed successfully; and C (gateway status) would typically cause refresh failures rather than a successful refresh with stale data.

Answer

Check row-level security (RLS) role assignments

Answer

Check the refresh history for errors

Answer

Verify the on-premises data gateway is running

Question 4

You need to create a Power BI report that shows sales by region and by product category. Users should be able to click on a region and see the sales for that region across all product categories. What is the best way to enable this?

Accepted Answer

Enable cross-filtering between the region slicer and the category chart. Cross-filtering is the simplest method. Option B is correct. Option A is wrong because drillthrough navigates to a detail page. Option C is wrong because tooltips don't change the visual. Option D is wrong because bookmarks require manual setup.

Answer

Set up a drillthrough page that filters by region

Answer

Use a report page tooltip to show category details

Answer

Create a bookmark for each region

Question 5

Which TWO of the following are valid ways to create a date table in Power BI? (Select two.)

Accepted Answer

Using DAX: DateTable = CALENDARAUTO(). Option B is correct because CALENDARAUTO() is a dedicated DAX table function that automatically scans all date columns in the model and returns a contiguous, complete date table spanning the earliest to latest dates, which is exactly what a date table requires. Option D is correct because Power Query can generate a continuous date list (e.g., with List.Dates or a start/end date range) and load it as a proper date table, a common and valid approach for building a calendar table. Option A is not a valid way to create a date table because DATESYTD is a time-intelligence function that returns year-to-date dates relative to a filter context, not a full contiguous calendar. Option C is incorrect because CALCULATE is a filter-modification function that expects a scalar expression and cannot return a table of distinct dates. Option E is incorrect because SUMMARIZE over Sales[Date] only yields the dates that actually appear in the fact table, producing gaps and not a complete date table.

Answer

Using DAX: DateTable = DATESYTD('Date'[Date])

Answer

Using DAX: DateTable = CALCULATE(DISTINCT(Sales[Date]))

Answer

Using DAX: DateTable = SUMMARIZE(Sales, Sales[Date])

Question 6

Which TWO of the following are true about using AI visuals in Power BI? (Select two.)

Accepted Answer

The Q&A visual allows users to type natural language questions. Option D is correct because the Q&A visual in Power BI lets users ask questions about their data in natural language (e.g., "total sales by region") and returns a visual answer, using the underlying semantic model's linguistic schema. Option E is correct because Key Influencers is an AI-powered native visual that applies machine learning to analyze which factors (categorical or numeric) most influence a target metric, ranking them by explanatory strength. Option A is wrong because Copilot requires a Fabric capacity (F64 or higher) or Power BI Premium capacity, not every license. Option B is wrong because Key Influencers is an AI visual, not a non-AI native visual. Option C is wrong because Smart Narratives is a built-in native Power BI visual, not a custom AppSource visual.

Answer

The Copilot feature is available in all Power BI licenses

Answer

The Key Influencers visual is a native visual available without AI

Answer

Smart Narratives is a custom visual from AppSource

Question 7

Which TWO of the following are valid methods to share a Power BI report with external users who do not have an internal Microsoft Entra ID account? (Select two.)

Accepted Answer

Deploy the report to Power BI Report Server and configure anonymous access. Option B is correct because Power BI Report Server is an on-premises deployment that can be configured to allow anonymous access, enabling external users without a Microsoft Entra ID account to view reports. Option C is correct because Microsoft Entra B2B collaboration lets you invite external users as guest accounts, giving them access to shared Power BI content without requiring an internal Entra ID identity. Option A is not appropriate here because Publish to web makes the report publicly accessible to anyone on the internet, which is not a controlled sharing method for external users. Option D is invalid because Power BI email subscriptions send a link to the report, not the report itself as an attachment, and recipients still need access permissions. Option E is incorrect because embedding a report in SharePoint Online still requires the viewer to authenticate with an account that has access to the Power BI content.

Answer

Publish to public web (Publish to web)

Answer

Send them an email subscription with the report attached

Answer

Embed the report in a SharePoint Online page and share the link

Question 8

You have a Power BI report that uses a composite model with both Import and DirectQuery sources. You need to ensure that a measure using SUMX performs well. What should you do?

Accepted Answer

Create a calculated column in the source system to pre-aggregate values. The correct option is C: create a calculated column in the source system to pre-aggregate values. In a composite model, SUMX is an iterator that must evaluate row by row, and when it runs against DirectQuery tables it can force expensive queries to the underlying source, so pre-aggregating in the source reduces the rows and computation the engine must process, improving performance. Disabling relationships (A) would break filter propagation and model semantics rather than help the measure. Replacing SUMX with CALCULATE (B) is not a valid substitution because CALCULATE changes filter context, not row-by-row aggregation. Replacing SUMX with SUM (D) only works if the data is already aggregated at the needed grain, and blindly changing it can produce incorrect results.

Answer

Disable relationships between tables

Answer

Use CALCULATE instead of SUMX

Answer

Replace SUMX with SUM and adjust the model

Question 9

You have a Power BI report that uses a custom visual from AppSource. The visual is not rendering correctly. What should you check first?

Accepted Answer

The visual is not certified by Microsoft.. Custom visuals are embedded in the report file when published from Power BI Desktop; they do not require a network connection to AppSource to render. If a visual is not rendering, first check whether the visual is certified by Microsoft, as the Power BI service administrator might have disabled the use of uncertified visuals. Option A is incorrect because the visual does not rely on a live connection to AppSource. Option B is incorrect because report themes only affect styling, not rendering. Option C is incorrect because RLS filters data but does not prevent visual rendering.

Answer

The network connection is blocked from reaching AppSource.

Answer

The visual is not compatible with the report theme.

Answer

The dataset has row-level security applied.

Question 10

You have a Power BI dataset with a large fact table. You need to optimize report performance when users filter by date. What should you do?

Accepted Answer

Mark the date table as a date table in Power BI.. Marking a table as a date table in Power BI designates it as the authoritative date dimension, which lets the engine apply built-in time intelligence and, critically, use the date column for automatic date filtering across the model. This enables Power BI to generate more efficient filter propagation and query plans when users slice by date, avoiding the slower behavior that occurs when date filtering falls back to a generic column. It also ensures the date column is treated as a proper date type for relationships and hierarchies.

Answer

Hide all columns except the date column.

Answer

Disable cross-filtering between tables.

Answer

Summarize the fact table by month.

Question 11

You are building a report that uses AI visuals from Power BI. You want to automatically detect outliers in sales data. Which visual should you use?

Accepted Answer

Key Influencers. The Key Influencers visual is correct because it uses AI-driven analytics to identify which factors most influence a metric and automatically surfaces outliers, segments, and drivers in the data, which matches the requirement to detect outliers in sales data. It ranks the impact of fields and can highlight unusual or unexpected contributors to sales values. The Q&A visual only lets users ask natural-language questions and returns standard visuals, so it does not perform outlier detection. Smart Narrative generates text-based summaries of a report page, and the Decomposition Tree enables ad hoc drill-down analysis, but neither automatically detects outliers as Key Influencers does.

Answer

Q&A visual

Answer

Smart Narrative

Answer

Decomposition Tree

Question 12

Which TWO are valid ways to distribute a Power BI report to users who do not have Power BI Pro licenses?

Accepted Answer

Embed the report in a Power BI app with Premium capacity.. Options B and C are correct. Power BI Premium capacity allows free users to view reports without a Pro license. Embedding a report in a Power BI app (Option B) within a Premium capacity workspace grants free users access. Publishing a report to a workspace backed by Premium capacity (Option C) also enables sharing with free users. Option A is incorrect because direct sharing via the Power BI service generally requires the recipient to have a Pro license unless the content is in a Premium capacity workspace, which is not stated. Option D is incorrect as a Power BI service distribution method because exporting to PDF and emailing it is a manual file export, not a controlled sharing feature within Power BI. Option E is incorrect because publishing to web makes the report publicly accessible, which is not a controlled distribution method for specific non-Pro users.

Answer

Share the report via Power BI service sharing.

Answer

Export the report as PDF and email it.

Answer

Publish to web (public).

Question 13

You have the DAX expression shown. It is intended to sum sales for the West region using an inactive relationship. However, the result is incorrect. What is the issue?

Accepted Answer

There may be multiple inactive relationships between Sales and Date, causing ambiguity.. USERELATIONSHIP activates a relationship, but if there are multiple inactive relationships between the same tables, it might not pick the intended one. Option A is wrong because the syntax is correct. Option C is wrong because the filter is applied correctly. Option D is wrong because there is no ambiguity in the filter.

Answer

The USERELATIONSHIP function syntax is incorrect.

Answer

The filter on Region should be in a separate CALCULATE.

Answer

The column names are case-sensitive and don't match.

Question 14

You have the measure shown. You add it to a table visual alongside columns from a related table. The total is higher than expected. What is the most likely cause?

Accepted Answer

The visual is expanding the measure due to a many-to-one relationship.. The correct option is C: the visual is expanding the measure due to a many-to-one relationship. When a measure from the many-side table is placed in a visual with columns from the related one-side table, the relationship can cause the measure to be evaluated across the expanded join, producing duplicated or inflated totals. This happens because the measure's filter context is not constrained to the original grain, so rows on the many side are counted multiple times. Option A is not the likely cause because granularity differences alone do not inflate totals in this way. Option B is incorrect because slicers are not required for correct aggregation, and Option D is wrong because switching SUM to SUMX does not fix relationship-driven expansion.

Answer

The Sales table is summarized at a different granularity.

Answer

The measure is not filtered by any slicer.

Answer

The measure should use SUMX instead of SUM.

Question 15

Your report contains a measure that calculates year-over-year growth. Users report that the measure returns blank for months where sales data exists in the current year but not in the previous year. How should you modify the measure to return 100% growth in such cases?

Accepted Answer

Use COALESCE(previous year sales, 1) in the denominator. None of the provided options are correct. The correct measure to return 100% growth when the previous year sales are blank is: IF(ISBLANK(PreviousYearSales), 1, DIVIDE(CurrentYearSales - PreviousYearSales, PreviousYearSales)). This explicitly handles the blank case by returning 1 (representing 100% growth) and uses the standard growth formula otherwise. Option A is incorrect because COALESCE(PreviousYearSales, 1) in the denominator yields (CurrentYearSales - 1)/1, which only equals 100% when CurrentYearSales = 2. Option B is incorrect because setting the previous year sales to 0 causes division by zero. Option C is incorrect because DIVIDE with alternate result 0 returns 0 instead of 100%. Option D is irrelevant as SELECTEDVALUE does not handle blanks in this context.

Answer

Wrap the previous year sales in IF(ISBLANK(...), 0, ...)

Answer

Use DIVIDE(current, previous, 0)

Answer

Use SELECTEDVALUE to ignore blank years