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

Question 1

You have a report that uses a custom visual from AppSource. The visual is not rendering correctly after a Power BI Desktop update. What is the best course of action?

Accepted Answer

Check for an updated version of the custom visual from the developer.. Checking for an updated version from the developer is the best step when a custom visual fails after a Power BI Desktop update. Option A is wrong because compatibility mode is not a feature for custom visuals; it applies to other settings. Option B is wrong because replacing with a built-in visual may not preserve the same functionality. Option D is wrong because simply removing and re-adding the visual from the marketplace does not address the underlying compatibility issue if no update is available.

Answer

Enable compatibility mode for the visual.

Answer

Replace the custom visual with a built-in visual.

Answer

Remove the visual and add it again from the marketplace.

Question 2

Which TWO actions improve the accessibility of a Power BI report for users with visual impairments?

Accepted Answer

Use a high-contrast color theme.. Options A and B are correct. A: Using a high-contrast color theme improves readability for visually impaired users. B: Adding alt text to visuals enables screen readers to describe the content. C is wrong because small font sizes reduce readability. D is wrong because high color saturation can be overwhelming and reduce contrast. E is wrong because complex drillthrough interactions can be confusing and hard to navigate.

Answer

Use small font sizes to fit more content.

Answer

Use high color saturation for all elements.

Answer

Include complex drillthrough interactions.

Question 3

Which THREE considerations are important when designing a dashboard for executive stakeholders?

Accepted Answer

Focus on key performance indicators (KPIs) that align with business goals.. The correct answers are A, B, and C. A is correct because dashboards for executives should focus on KPIs aligned with business goals to provide actionable insights. B is correct because consistent use of colors and fonts enhances readability and maintains a professional appearance. C is correct because high-level summaries with drill-down capability allow executives to quickly grasp the big picture while having the option to explore details. D is incorrect because including too many interactive slicers can overwhelm users and reduce clarity; they should be used sparingly. E is incorrect because detailed tables are better suited for operational reports; dashboards should emphasize visual summaries.

Answer

Include as many interactive slicers as possible for flexibility.

Answer

Use detailed tables to show all underlying data.

Question 4

Which TWO actions can you take to improve the performance of a Power BI report that uses a large dataset?

Accepted Answer

Use aggregations to pre-summarize data at higher levels.. Options B and D are correct. Using aggregations pre-summarizes data at higher levels, reducing the amount of data processed by the report. Reducing the number of visuals on a page decreases the processing load. Option A is wrong because using multiple columns in slicers increases cardinality and can degrade performance. Option C is wrong because complex calculated measures with many nested functions can be resource-intensive. Option E is wrong because switching to DirectQuery mode may lead to slower performance with large datasets due to repeated queries to the source.

Answer

Use multiple columns in slicers for more granular filtering.

Answer

Create complex calculated measures that use many nested functions.

Answer

Switch from Import mode to DirectQuery mode.

Question 5

You are building a Power BI report that shows sales by region. You want to use a visual that displays hierarchical data, such as region -> country -> city, and allows drilling up and down. Which visual should you use?

Accepted Answer

Decomposition tree. The decomposition tree visual in Power BI allows users to drill down and up through hierarchical data (e.g., region -> country -> city) and perform root cause analysis. Option A (Scatter plot) is used for showing relationships between two numeric variables, not hierarchical drill-down. Option B (Stacked bar chart) does not natively support hierarchical drill-down without additional setup. Option C (Card) displays a single value and supports no hierarchical navigation. Therefore, the correct choice is D.

Answer

Scatter plot

Answer

Stacked bar chart

Answer

Card

Question 6

You have a Power BI report that uses a measure to calculate year-over-year growth. Users report that the measure returns blank for certain months. The measure is: YoY Growth = DIVIDE(SUM(Sales[Amount]) - CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR('Date'[Date])), CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR('Date'[Date]))). What is the most likely cause of the blank values?

Accepted Answer

The Date table is missing dates for the previous year, causing SAMEPERIODLASTYEAR to return no data.. SAMEPERIODLASTYEAR depends on a complete date range. If the Date table lacks dates for the previous year (e.g., missing months), SAMEPERIODLASTYEAR may return no data, causing the DIVIDE function to return blank. Option A is incorrect because marking the Date table as a date table is not required for SAMEPERIODLASTYEAR to return blank. Option B is incorrect because DIVIDE returns blank when the denominator is zero, but here the denominator is CALCULATE(..., SAMEPERIODLASTYEAR), which may be blank due to missing dates, not zero. Option D is incorrect because TOTALYTD calculates year-to-date, not year-over-year growth.

Answer

The Date table is not marked as a date table.

Answer

The measure uses DIVIDE which returns blank when denominator is zero.

Answer

The measure should use TOTALYTD instead of SAMEPERIODLASTYEAR.

Question 7

You need to create a Power BI report that allows users to select a single measure from a list to display on a card visual. Which feature should you use?

Accepted Answer

Field parameters. Field parameters allow users to dynamically switch between measures, enabling a card visual to display different metrics based on user selection. Option A is incorrect because bookmarks capture a specific state of the report, not dynamic selection of measures. Option B is incorrect because tooltips provide hover details and do not allow changing the measure displayed. Option D is incorrect because drill-through navigates to a detail page filtered by a context, not switching measures on the same visual.

Answer

Bookmarks

Answer

Tooltips

Answer

Drill-through

Question 8

You are designing a Power BI report that will be viewed on mobile devices. The report contains a complex scatter plot with many data points. Users complain that the visual is hard to interact with on small screens. What is the best approach to improve the mobile experience?

Accepted Answer

Create a separate mobile layout and replace the scatter plot with a simpler visual like a line chart.. The best approach because Power BI allows creating a separate mobile layout optimized for small screens. Replacing a complex scatter plot with a simpler visual like a line chart improves readability and touch interaction on mobile devices. Option A is incorrect because bookmarks do not fundamentally improve the visual's interactivity on small screens. Option B is incorrect because adding a slicer does not address the core issue of the scatter plot being too complex for mobile. Option C is incorrect because simply increasing the size may hide other visuals and does not improve the touch interaction for dense data points.

Answer

Use bookmarks to switch between the scatter plot and a table.

Answer

Keep the scatter plot but add a slicer to filter data.

Answer

Increase the size of the scatter plot to fill the screen.

Question 9

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. The Q&A visual allows users to ask natural language questions and receive visual answers directly in a Power BI report. Option B, Key influencers visual, is used for analyzing factors that drive a metric. Option C, Copilot for Power BI, provides AI assistance but is not specifically designed for natural language queries within a report; it is more for creating and editing content. Option D, Decomposition tree, enables hierarchical drill-down analysis.

Answer

Key influencers visual

Answer

Copilot for Power BI

Answer

Decomposition tree

Question 10

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.. The date table does not contain a continuous range of dates for the entire year. DATESYTD requires a continuous date range to compute accurate year-to-date values. If the date table is missing dates (e.g., only contains business days or starts mid-year), the YTD calculation may return incorrect results, especially at the beginning of the year when gaps are most noticeable. Option A is incorrect because single-directional relationships do not prevent DATESYTD from working. Option C is incorrect because month granularity is not the issue; DATESYTD works with any granularity as long as dates are continuous. Option D is incorrect because DATESYTD does not require the date table to be marked as a date table; it only needs a valid date column.

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.

Question 11

You are troubleshooting a Power BI report that uses a measure with the following formula: Profit Margin = DIVIDE(SUM(Transactions[Profit]), SUM(Transactions[Revenue])). The measure returns blank for rows where revenue is zero. You want to display 0% instead of blank. What should you do?

Accepted Answer

Add a third argument to DIVIDE: DIVIDE(SUM(Transactions[Profit]), SUM(Transactions[Revenue]), 0).. The third argument of the DIVIDE function specifies an alternate result when division by zero occurs, returning 0 instead of blank. Option A is incorrect because COALESCE replaces blank with 0 after the fact, but DIVIDE still returns blank when revenue is zero, so COALESCE would not receive a blank from the measure directly. Option C is incorrect because IFERROR does not catch blank values; it only catches errors. Option D is incorrect because using IF(ISBLANK) works but is less efficient than using the third argument of DIVIDE, and the question asks for the best method.

Answer

Use COALESCE([Profit Margin], 0).

Answer

Use IFERROR( [Profit Margin], 0).

Answer

Wrap the measure with IF(ISBLANK([Profit Margin]), 0, [Profit Margin]).

Question 12

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

Accepted Answer

Using the CALENDAR function to generate a date table.. The CALENDAR function is a DAX function that can be used to create a calculated date table. Option B is correct because DAX expressions like SUMMARIZE and ADDCOLUMNS can be used to create calculated tables. Option C is incorrect because the 'New Table' button under the 'Modeling' tab creates a calculated table using DAX, not Power Query. Option D is incorrect because calculated tables are defined in DAX, not M language. Option E is incorrect because the Fields pane does not have an option to create a calculated table via right-click; calculated tables are created through the Modeling tab or using DAX.

Answer

Using the 'New Table' button under the 'Modeling' tab and writing a Power Query expression.

Answer

Using M language in Power Query Editor.

Answer

By right-clicking a table in the Fields pane and selecting 'New calculated table'.

Question 13

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

Accepted Answer

Ensure tab order is logical for keyboard navigation.. For Power BI reports to be accessible, best practices include ensuring logical tab order for keyboard navigation (Option B) so that users who rely on screen readers or keyboard-only navigation can interact with elements in a meaningful sequence. High color contrast between text and background (Option C) improves readability for users with low vision or color blindness. Providing alt text for all visual elements (Option E) allows screen readers to describe charts, graphs, and images. Option A is incorrect because 3D effects can cause visual clutter and may be difficult to interpret for users with visual impairments. Option D is incorrect because using too many colors can confuse users and make data harder to differentiate; accessible design uses a limited, distinct color palette.

Answer

Use 3D effects to make visuals more engaging.

Answer

Use as many colors as possible to differentiate data.

Question 14

Which TWO of the following are required to use Copilot in Power BI? (Select two.)

Accepted Answer

A Power BI Premium capacity (PPU or Premium Gen2).. Options D and E are correct because Copilot in Power BI requires either a Power BI Premium capacity (PPU or Premium Gen2) or a Fabric license (F64 or higher). Option A is wrong because datasets can be imported or created from various sources, not necessarily from scratch. Option B is wrong because Copilot is available in both Power BI Desktop and the Power BI service. Option C is wrong because Copilot does not require custom visuals; it works with standard visuals and reports.

Answer

A dataset created from scratch in Power BI Desktop.

Answer

Power BI Desktop only (service not supported).

Answer

A report with at least one visual using a custom visual.

Question 15

You have a Power BI report that uses a DirectQuery connection to a large SQL Server data warehouse. Users report that slicers and filters are slow to respond. What should you recommend to improve performance?

Accepted Answer

Optimize the SQL queries and add appropriate indexes in the data warehouse.. Optimizing the source query with indexes, aggregations, and reducing data volume improves DirectQuery performance. Option B is wrong because a live connection is essentially the same as DirectQuery in terms of performance; it still sends queries to the source, so it doesn't improve performance. Option C is wrong because increasing memory allocated to Power BI service does not affect the query performance of DirectQuery, which executes on the source. Option D is wrong because switching to Import mode would require moving large amounts of data and may not be feasible, and while Import mode can be faster for querying, it involves data movement and latency in refresh.

Answer

Change the connection to a live connection to the data warehouse.

Answer

Increase the memory allocated to the Power BI service capacity.

Answer

Switch the report to Import mode and schedule refreshes.