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

Question 1

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. Calculated columns are evaluated at refresh time and stored in memory. They can degrade performance. Option B is correct: convert to a measure if possible. Option A is wrong because incremental refresh is for imports, not live connections. Option C is wrong because disabling interactions would hide the issue. Option D is wrong because calculated columns are not faster.

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 2

You are designing a Power BI report for a sales team. The team needs to see revenue by product category, but also want to view daily trends for a selected product. The data has over 10 million rows. What visual design approach minimizes report load time?

Accepted Answer

Create a drillthrough page with a line chart showing daily revenue, and use category page as source. Using a drillthrough page with a single visual reduces initial load. Option A is correct. Option B is wrong because a single visual with all categories may be slow. Option C is wrong because bookmarks add complexity. Option D is wrong because custom visuals may have overhead.

Answer

Use a custom visual that combines both views in one chart

Answer

Use bookmarks to switch between category view and daily trend view

Answer

Place a stacked column chart showing all categories and a line chart for trend on the same page

Question 3

You want to create a measure that calculates the percentage of total sales for each product category. What DAX function should you use to get the grand total?

Accepted Answer

ALL. ALL removes filters from a table or column. Option A is correct. Option B is wrong because ALLSELECTED respects user filter selections. Option C is wrong because REMOVEFILTERS is similar but less common for this use. Option D is wrong because VALUES returns distinct values.

Answer

VALUES

Answer

ALLSELECTED

Answer

REMOVEFILTERS

Question 4

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 dataset might be using incremental refresh with a filter that excludes recent data, or the source data hasn't updated. Option C is correct. Option A is wrong because refresh history shows success. Option B is wrong because gateway is not the issue. Option D is wrong because role permissions don't affect data freshness.

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 5

You have a Power BI semantic model with a date table that has a 1:* relationship to a Sales table. You need to create a measure that shows the number of sales transactions for the last 30 days. The date table is marked as a date table. Which DAX expression should you use?

Accepted Answer

CALCULATE(COUNTROWS(Sales), DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -30, DAY)). DATESINPERIOD returns a set of dates going back 30 days from the last date in filter context. Option D is correct. Option A is wrong because DATEADD moves by intervals, not necessarily 30 days back from today. Option B is wrong because PREVIOUSMONTH returns a month. Option C is wrong because DATESBETWEEN requires explicit start and end dates.

Answer

CALCULATE(COUNTROWS(Sales), DATESBETWEEN('Date'[Date], TODAY()-30, TODAY()))

Answer

CALCULATE(COUNTROWS(Sales), PREVIOUSMONTH('Date'[Date]))

Answer

CALCULATE(COUNTROWS(Sales), DATEADD('Date'[Date], -30, DAY))

Question 6

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 7

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 A is valid by using CALENDARAUTO. Option D is valid by using Power Query to generate a list of dates. Option B is wrong because CALCULATE is a function, not a table constructor. Option C is wrong because DATESYTD returns a table of dates but only for a year-to-date period, not a full date table. Option E is wrong because SUMMARIZE returns a summary table, not a 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 8

Which THREE of the following are best practices when designing Power BI reports for mobile devices? (Select three.)

Accepted Answer

Create a dedicated mobile layout view. Option A is correct because Power BI provides a dedicated mobile layout view that allows you to optimize report pages specifically for mobile devices. By using this view, you can rearrange, resize, and hide visuals to ensure they display properly on smaller screens, which is a best practice for mobile report design.

Answer

Use custom visuals for advanced analytics

Answer

Include multiple slicers for flexible filtering

Question 9

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 A is correct: Q&A allows natural language queries. Option D is correct: Key Influencers visual uses machine learning to analyze factors. Option B is wrong: Decomposition Tree is an AI visual, not a native visual. Option C is wrong: Smart Narratives is a visual, not a custom visual. Option E is wrong: Copilot is a feature that can be enabled, but it's not a visual type.

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 10

Which THREE of the following are valid considerations for choosing between Import and DirectQuery storage modes? (Select three.)

Accepted Answer

Import mode provides faster query performance for aggregated data. Option A is correct: Import mode has size limits. Option C is correct: DirectQuery provides real-time access. Option D is correct: Import mode offers faster performance. Option B is wrong: DirectQuery can query large data, but Import can also handle large data via incremental refresh. Option E is wrong: DirectQuery does not support all DAX functions, but the statement is too absolute.

Answer

DirectQuery mode supports all DAX functions without limitations

Answer

DirectQuery mode cannot query large data sources

Question 11

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: Use Azure AD B2B guest accounts. Option C is correct: Publish to Power BI Report Server (on-premises) allows anonymous access or forms auth. Option A is wrong: Publish to web makes the report public. Option D is wrong: Email subscription sends a snapshot, not interactive. Option E is wrong: Embed in SharePoint requires internal users.

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 12

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. In composite models, iterating over DirectQuery tables can be slow. Option C is correct: move the calculation to the source (e.g., SQL view). Option A is wrong because reducing cardinality may not help. Option B is wrong because disabling relationships is not practical. Option D is wrong because changing to SUM might change logic.

Answer

Disable relationships between tables

Answer

Use CALCULATE instead of SUMX

Answer

Replace SUMX with SUM and adjust the model

Question 13

You have a Power BI report that shows sales by region. The map visual displays regions with incorrect boundaries. What is the most likely cause?

Accepted Answer

Bing Maps geocoding inaccuracies.. Option B is correct because map visuals in Power BI use Bing Maps, which may have inaccurate or outdated geographic data. Option A is wrong because data source refresh does not affect map boundaries. Option C is wrong because the issue is not related to visual type selection. Option D is wrong because map labels do not affect boundaries.

Answer

The map visual is not the best choice for the data.

Answer

The data source is not refreshed.

Answer

The map labels are overlapping.

Question 14

You need to create a measure that calculates the year-over-year growth of sales. Which DAX function should you use?

Accepted Answer

SAMEPERIODLASTYEAR. Option C is correct because SAMEPERIODLASTYEAR returns the same period last year, which is used in YoY calculations. Option A is wrong because PARALLELPERIOD shifts by a full period, not necessarily the same days. Option B is wrong because DATEADD can shift by any interval. Option D is wrong because PREVIOUSYEAR returns the full previous year, not the same period.

Answer

DATEADD

Answer

PARALLELPERIOD

Answer

PREVIOUSYEAR

Question 15

You are designing a report for executives. They need to see both high-level KPIs and the ability to drill down into details. Which approach should you recommend?

Accepted Answer

Use drillthrough pages to navigate from summary visuals to detail pages.. Option A is correct because drillthrough pages allow users to click on a high-level visual and see detailed data for that context. Option B is wrong because tooltips show only summary information, not detailed drilldown. Option C is wrong because bookmarks navigate to different states but not a dedicated detail page. Option D is wrong because a single table visual does not provide high-level KPI overview.

Answer

Place all data in a single table visual with drill-down capability.

Answer

Use bookmarks to switch between summary and detail views.

Answer

Use report page tooltips to show details on hover.