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

Question 1

You are designing a Power BI report for executives. The report must show sales performance across regions, with the ability to drill down from region to country to city. The data model includes a Sales table and a Geography table. Which type of hierarchy should you create in the Geography table to enable drill-down?

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

Accepted Answer

Create a standard multi-level hierarchy in the Geography table using the region, country, and city columns.. Creating a standard multi-level hierarchy (grouping) on the Geography table using the region, country, and city columns enables drill-down in Power BI visuals. Options A, B, and D do not create a proper hierarchy for drill-down.

Answer

Create a calculated table that combines region, country, and city.

Answer

Create a relationship between the Sales table and a Geography table that includes region, country, and city columns.

Answer

Add a calculated column that concatenates region, country, and city.

Question 2

You are creating a Power BI report that includes a matrix visual showing sales by product category and year. You want to highlight the highest sales value in each category. Which conditional formatting option should you use?

Accepted Answer

Color by rules with a rule to highlight the maximum value per category.. 'Color by rules' can be configured with a rule to highlight the maximum value per category (e.g., by setting the rule to 'Top N' = 1 based on each category). Option A is wrong because 'Color by color scale' applies a gradient across the matrix, not specifically highlighting the maximum per category. Option B is wrong because 'Icons with a traffic light icon set' are typically used for thresholds (like high/medium/low) and not for dynamically highlighting the per-category maximum. Option D is wrong because 'Data bars' display bar lengths proportional to values, but they do not single out the maximum value.

Answer

Color by color scale with a diverging gradient.

Answer

Icons with a traffic light icon set.

Answer

Data bars with a bar color.

Question 3

You are building a Power BI report that uses a composite model with a DirectQuery source and an imported local table. You want to create a measure that aggregates data from both sources. What must you ensure?

Accepted Answer

The relationships between tables must be defined correctly.. In composite models, measures can aggregate data from multiple sources only if the relationships between tables are defined correctly. Option B is incorrect because measures can indeed use columns from both sources when relationships exist. Option C is incorrect because storage modes can differ (DirectQuery and Import) in a composite model. Option D is incorrect because the local table does not need to be converted; import and DirectQuery tables can coexist in a composite model.

Answer

You cannot create measures that use columns from both sources.

Answer

Both tables must be set to the same storage mode (DirectQuery or Import).

Answer

The local table must be converted to DirectQuery.

Question 4

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.. Calculated columns are computed only during dataset refresh and remain static until the next refresh. They do not automatically recalculate when underlying data changes. Option A is incorrect because measures update dynamically, but the issue is that the column is not updating. Option C is incorrect because incorrect syntax would result in an error, not a failure to refresh. Option D is incorrect because the function used does not prevent updates; calculated columns are inherently static until refresh.

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 5

You are designing a Power BI report that will be viewed on mobile devices. The report includes many visuals. What is the best practice for optimizing the report layout for mobile?

Accepted Answer

Create a mobile-optimized layout using the Phone layout view.. Power BI Desktop includes a Phone layout view that allows you to create a mobile-optimized layout by rearranging and resizing visuals specifically for small screens. This is the best practice for mobile report design. Option B is incorrect because table visuals do not provide a mobile-friendly experience; they are not optimized for small screens. Option C is incorrect because bookmarks help with navigation but do not inherently optimize the layout for mobile devices. Option D is incorrect because reducing visuals to one per page may oversimplify the report but is not the recommended mobile optimization feature in Power BI.

Answer

Use a table visual to display all data.

Answer

Use bookmarks to navigate between different views.

Answer

Reduce the number of visuals to one per page.

Question 6

You have a Power BI dataset with a fact table and multiple dimension tables. You need to ensure that when a user filters by a dimension, the filter propagates correctly to the fact table. What type of relationship should you use?

Accepted Answer

One-to-many from dimension to fact.. A one-to-many relationship from dimension to fact is the standard for star schemas, allowing filters on the dimension table to propagate correctly to the fact table. Option A is incorrect because many-to-one from fact to dimension is the same cardinality but opposite direction; the correct direction is dimension to fact. Option C is incorrect because one-to-one relationships are rare in star schemas and not needed for typical filtering. Option D is incorrect because many-to-many relationships can cause ambiguous filtering and are not recommended for standard scenarios.

Answer

Many-to-one from fact to dimension.

Answer

One-to-one between dimension and fact.

Answer

Many-to-many between dimension and fact.

Question 7

You are creating a Power BI report and want to allow users to ask questions about the data using natural language. Which feature should you enable?

Accepted Answer

Q&A visual.. Q&A visual. This feature allows users to ask natural language questions about the data and receive answers in the form of visuals. Option A (Quick Insights) automatically generates insights but does not support interactive Q&A. Option B (Key Influencers visual) identifies factors that influence a metric, not natural language queries. Option D (Copilot for Power BI) is an AI assistant that can help with various tasks, but the specific feature for natural language Q&A is the Q&A visual.

Answer

Quick Insights.

Answer

Key Influencers visual.

Answer

Copilot for Power BI.

Question 8

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

Accepted Answer

Provide alternative text for visuals.. Options A and C are correct. Providing alternative text for visuals allows screen readers to describe the visuals to visually impaired users. Ensuring sufficient color contrast between text and background improves readability for users with low vision or color blindness. Option B is incorrect because animations can be distracting and may cause accessibility issues for users with cognitive or visual impairments. Option D is incorrect because using many colors can confuse color-blind users; it is better to use patterns or labels. Option E is incorrect because small font sizes reduce readability, especially for users with visual impairments.

Answer

Use animations to draw attention.

Answer

Use a variety of colors to differentiate data points.

Answer

Use small font sizes to fit more data.

Question 9

Which THREE of the following are valid ways to share a Power BI report with users who do not have a Power BI Pro license? (Select THREE.)

Accepted Answer

Embed the report in a secure portal or website using the embed option for internal users.. Options A, C, and E are correct. Option B is wrong because sharing via email requires Pro. Option D is wrong because publishing to web makes report public, which may not be desired.

Answer

Share the report directly from the Power BI service by entering the user's email address.

Answer

Publish the report to the web (public) and share the link.

Question 10

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

Accepted Answer

Use the DAX expression with the SUMMARIZE function.. The SUMMARIZE function in DAX creates a calculated table by grouping data from one or more tables, returning a new table with distinct combinations of the specified columns. This is a standard way to generate a calculated table in Power BI for further analysis or modeling.

Answer

Use the Merge Queries feature in Power Query Editor.

Answer

Use the Split Column feature in Power Query Editor.

Answer

Use the Group By feature in a matrix visual.

Question 11

You have a Power BI report that includes a pie chart. Users complain that it is difficult to compare the sizes of slices. Which visual should you recommend instead to improve comparison?

Accepted Answer

A bar chart.. For comparing the sizes of slices in a pie chart, a bar chart is the most effective because it uses length along a common baseline, making it easier to compare values accurately. Treemaps and donut charts have similar issues to pie charts in comparing areas or angles. Scatter plots are used for relationships, not comparisons of categorical values.

Answer

A treemap.

Answer

A donut chart.

Answer

A scatter plot.

Question 12

You have a Power BI report that uses a live connection to an Azure Analysis Services tabular model. Users report that the report loads slowly when filtering by a specific date range. You need to improve performance without changing the data source. What should you do?

Accepted Answer

Enable the 'Reduce queries sent to the source' option in the report settings.. Enabling the 'Reduce queries sent to the source' option (also known as Query Reduction) in Power BI Desktop report settings reduces the number of DAX queries sent to the live connection by combining filters and applying them in a single query. This improves performance without changing the data source. Option A is incorrect because changing storage mode to Import would change the data source behavior and is not allowed per the requirement. Option B is incorrect because visual-level filters still require the same amount of queries to the source. Option C is incorrect because field parameters affect measure selection, not query reduction.

Answer

Change the storage mode to Import for the fact table.

Answer

Apply a visual-level filter to limit the date range.

Answer

Create a field parameter to allow users to select measures.

Question 13

You create a Power BI report that includes a page with a matrix visual showing sales by region and product category. You want users to be able to drill down from region to salesperson level. What is the best way to enable this?

Accepted Answer

Add the Salesperson field to the matrix rows hierarchy below Region.. Adding the Salesperson field below the Region field in the matrix rows creates a hierarchy that supports drill-down. Option A is wrong because drill-through navigates to a different page and does not provide drill-down within the same visual. Option B is wrong because bookmarks switch between views but do not enable drill-down in the matrix. Option D is wrong because tooltips provide additional information on hover but do not support drill-down behavior.

Answer

Set up drill-through from the region to a salesperson detail page.

Answer

Use bookmarks to switch between region and salesperson views.

Answer

Enable tooltips that show salesperson details on hover.

Question 14

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" & QUARTER(EDATE('Date'[Date], -6)). To calculate the fiscal quarter when the fiscal year starts in July, shift the date back by 6 months using EDATE, then apply QUARTER. Option C correctly implements this. Option A uses an invalid format string. Option B uses FORMAT with 'Q' which returns the calendar quarter, not the fiscal quarter. Option D uses QUARTER directly on the date, also returning the 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 15

You have a Power BI dataset with a fact table containing sales transactions and a dimension table for customers. The customer dimension includes a calculated column that uses the LOOKUPVALUE function to retrieve a customer's region from another table. The report performance is slow. What should you do to improve performance?

Accepted Answer

Remove the LOOKUPVALUE column and instead create a relationship between the tables.. LOOKUPVALUE is a row-by-row operation that can be slow on large datasets. Creating a relationship between the tables and using the RELATED function (or merging in Power Query) is much more efficient. Option A is incorrect because disabling 'Reduce queries sent to the source' would degrade performance by sending more queries. Option B is incorrect because incremental refresh applies to data loading, not to the efficiency of calculated columns. Option D is incorrect because adding RAM does not address the root cause of the inefficient LOOKUPVALUE calculation; it only masks performance issues.

Answer

Disable the 'Reduce queries sent to the source' option.

Answer

Enable incremental refresh on the fact table.

Answer

Increase the amount of RAM on the Power BI service capacity.