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

Question 1

You are building a Power BI report to analyze customer churn. You want to add a visual that shows the trend of churn rate over time. Which visual type is most appropriate?

Accepted Answer

Line chart. A line chart is best for showing trends over time. Option B is wrong because a stacked bar chart is better for comparing parts of a whole. Option C is wrong because a scatter plot shows correlation between two variables. Option D is wrong because a pie chart shows proportions at a single point in time.

Answer

Stacked bar chart

Answer

Scatter plot

Answer

Pie chart

Question 2

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.. COALESCE(CurrentYear, 0) returns 0 when CurrentYear is blank, allowing the growth calculation to show 0% growth. Option A is wrong because ISBLANK(CurrentYear) in an IF statement would still result in blank if you don't provide an alternate value. Option B is wrong because checking if PreviousYear = 0 does not address blank CurrentYear. Option C is wrong because DIVIDE with an alternate result of 0 only handles division by zero, not blank numerator.

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 3

You have a Power BI report that includes a map visual showing store locations. You want to add a tooltip that displays the store name and total sales when users hover over a location. What do you need to do?

Accepted Answer

Add the store name and sales fields to the tooltips bucket of the map visual.. Tooltips in Power BI are configured by adding fields to the tooltips bucket of a visual. Option B is wrong because bookmarks are used to capture and switch between different states of a report, not for tooltips. Option C is wrong because drill-through is for navigating to another page with related details, not for hover tooltips. Option D is wrong because the page tooltip property applies to the entire page, not to individual visuals.

Answer

Create a bookmark that shows a table with store details.

Answer

Add a drill-through page with store details.

Answer

Set the page tooltip property to show store details.

Question 4

You are designing a Power BI dashboard for executive management. Which TWO practices should you follow to ensure the dashboard is effective?

Accepted Answer

Use consistent color coding across visuals.. Options D and E are correct. D: Using consistent color coding helps users quickly interpret data. E: Limiting the dashboard to the most important KPIs focuses on what matters. Option A is wrong because real-time refresh may not be necessary and can impact performance. Option B is wrong because too many visuals clutter the dashboard. Option C is wrong because a dark background may not always make visuals stand out and can reduce readability.

Answer

Configure real-time data refresh for all data sources.

Answer

Include as many visuals as possible on a single dashboard page.

Answer

Use a dark background to make visuals stand out.

Question 5

You have a Power BI dataset that includes a Sales table with a column 'TransactionDate'. You need to create a date dimension table using DAX. Which THREE of the following are recommended practices?

Accepted Answer

Use CALENDARAUTO() to automatically generate the date range.. Options A, C, and E are correct. A: Using CALENDARAUTO() automatically generates a continuous range of dates based on the data in the model, which is efficient and captures all necessary dates for time intelligence. C: Including dates from January 1 of the earliest year to December 31 of the latest year ensures a full calendar year range, which is best practice for date tables. E: Marking the table as a date table in Power BI enables time intelligence functions like TOTALYTD and PREVIOUSMONTH to work correctly. Option B is wrong because using DISTINCT on Sales[TransactionDate] may miss dates that have no transactions, leading to gaps in the date table. Option D is wrong because manually creating each date column with ADDCOLUMNS is inefficient and error-prone; it is better to use DAX functions like CALENDAR or CALENDARAUTO to generate the date range and then add calculated columns.

Answer

Use DISTINCT(Sales[TransactionDate]) to create the date table.

Answer

Create each date column manually using ADDCOLUMNS.

Question 6

You are building a Power BI report that uses a DirectQuery source. Which TWO of the following actions can improve report performance?

Accepted Answer

Reduce the number of visuals on each report page.. Options C and E are correct. C: Reducing the number of visuals on a report page decreases the number of queries sent to the DirectQuery source, improving performance. E: Creating summary tables in the data source to pre-aggregate data reduces the workload on Power BI by returning pre-aggregated results faster. Option A is wrong because calculated columns are computed row-by-row and increase query complexity. Option B is wrong because disabling 'Reduce queries' would increase queries sent to the source. Option D is wrong because complex DAX measures often lead to inefficient query plans and longer response times.

Answer

Add calculated columns to the model.

Answer

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

Answer

Use complex DAX measures with many nested functions.

Question 7

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, B, and C are correct. A: Slicers allow users to filter data interactively by date, product, and region. B: Bookmarks enable users to save and switch between different report views, enhancing navigation. C: Drill-through pages provide detailed analysis for a selected data point. Option D is wrong because disabling cross-filtering reduces interactivity between visuals. Option E is wrong because default tooltips provide limited information; custom tooltips or other features are better for enhancing user experience.

Answer

Disable cross-filtering between visuals.

Answer

Use only default tooltips.

Question 8

You have a Power BI dataset that uses row-level security (RLS) with roles defined in Power BI Desktop. You publish the dataset to the Power BI service. Which TWO statements are true about RLS behavior?

Accepted Answer

Users assigned to a role will only see rows that satisfy the role's DAX filter.. The correct answers are B and E. RLS filters data at the row level based on the DAX filter defined for each role, so users assigned to a role only see rows that satisfy that filter (B). Role membership must be assigned in the Power BI service after publishing the dataset, as roles are defined in Power BI Desktop but membership is managed in the service (E). Option A is incorrect because RLS does not affect the dataset refresh schedule. Option C is incorrect because visual titles are not automatically filtered by RLS; RLS filters the underlying data rows. Option D is incorrect because RLS applies to rows, not measures; measures are calculated based on the filtered rows.

Answer

RLS affects the refresh schedule of the dataset.

Answer

Visual titles are automatically filtered based on RLS.

Answer

RLS can restrict access to specific measures.

Question 9

You are a Power BI data analyst at a global retail company. Your organization uses a SQL Server data warehouse to store sales transactions, product inventory, and customer demographics. The data warehouse is updated nightly. You have been tasked with building a Power BI report to analyze sales performance across different regions and product categories. The report must meet the following requirements:

- Allow users to filter data by date, region, and product category.
- Provide drill-down from region to store level.
- Display key metrics such as total sales, sales growth compared to the previous year, and profit margin.
- Ensure that the report loads quickly even when users apply multiple filters.
- Users must be able to export the underlying data to Excel for further analysis.
- The report should be accessible on mobile devices with a responsive layout.
- You need to implement row-level security so that regional managers can only see data for their own region.
- The dataset must support scheduled refresh.

You have imported the necessary tables from the data warehouse using Import mode. You created a date dimension table using DAX and marked it as a date table. You also created a separate table for regions with a column 'RegionManagerEmail' that maps each region to the manager's email address. You plan to use RLS by creating a role that filters the region table based on the user's email address.

After publishing the report to the Power BI service, you notice that the report takes a long time to load when users select a large date range. Additionally, the profit margin measure, which is calculated as DIVIDE(SUM(Sales[Profit]), SUM(Sales[Revenue])), returns blank for some rows even though both Profit and Revenue have values. You also receive feedback that the mobile layout is not optimized; the visuals are too small and the slicers are not accessible.

You need to address these issues. What should you do?

Accepted Answer

Create aggregations on the fact table in the data source to reduce data volume, verify relationships for the profit margin measure, and use the Power BI mobile layout view to optimize visuals and slicers.. Creating aggregations on the fact table in the data source (e.g., pre-aggregated daily sales) reduces the amount of data loaded into the model, improving load times. The profit margin issue is likely due to a missing relationship or filter context; verifying relationships and using DIVIDE with an alternate result will fix blanks. For mobile layout, using the mobile layout view to resize visuals and place slicers at the top improves accessibility. Option A is wrong because incremental refresh alone does not address the profit margin issue or the mobile layout; it only helps with data refresh performance. Option B is wrong because switching to DirectQuery could actually slow down query performance due to frequent data source queries, and it does not fix the profit margin or mobile layout issues. Option D is wrong because increasing capacity or enabling large dataset storage does not solve the specific performance problem caused by loading excessive data or the profit margin calculation issue.

Answer

Implement incremental refresh on the fact table and create a separate measure for profit margin using COALESCE.

Answer

Change the storage mode to DirectQuery for the fact table and use the Power BI Desktop's 'Optimize for mobile' option.

Answer

Increase the capacity of the Power BI service to Premium Per User and enable large dataset storage.

Question 10

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

Accepted Answer

SAMEPERIODLASTYEAR. SAMEPERIODLASTYEAR is the most direct and semantically clear function for year-over-year comparisons because it returns the same period in the prior year without requiring complex interval arguments. While DATEADD('Date'[Date], -1, YEAR) produces the same result, SAMEPERIODLASTYEAR is specifically designed for this purpose and is easier to read. PARALLELPERIOD, on the other hand, shifts entire periods and may not align with the current granularity (e.g., a monthly context would return the full prior year).

Answer

DATEADD

Answer

DATESYTD

Answer

PARALLELPERIOD

Question 11

You are designing a report for executives. The report contains a matrix visual with many rows and columns. Users complain that the visual is slow to render. Which design change would most improve performance?

Accepted Answer

Use a drill-down hierarchy instead of expanding all levels.. Aggregating data at a higher level reduces the number of data points, improving performance. Drilling down can still provide detail when needed.

Answer

Switch to a table visual.

Answer

Add more filters to the visual.

Answer

Increase the number of measures in the matrix.

Question 12

You have a Power BI report that uses a slicer to filter data by year. You want the slicer to show only years that have data, but currently it shows all years from 2000 to 2030. What is the most likely cause?

Accepted Answer

The year field is from a disconnected table.. If the slicer field is from a disconnected date table or the relationship is not filtering correctly, the slicer shows all values. The solution is to use a date table related to the fact table.

Answer

The slicer is using a calculated column.

Answer

The slicer is set to 'Single select' mode.

Answer

The data model uses a star schema.

Question 13

You need to create a KPI visual that shows whether current sales are above or below target. Which fields are required for a KPI visual?

Accepted Answer

Value, Trend axis, and Target. A KPI visual requires a Value (measure for current sales), a Trend axis (usually date), and a Target (goal).

Answer

Value, Trend axis, and Category

Answer

Value and Trend axis only

Answer

Value and Target only

Question 14

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 15

You have a Power BI dataset with a many-to-many relationship between Sales and Product. You need to create a measure that sums sales amount by product category, but the relationship is causing incorrect totals. What is the best solution?

Accepted Answer

Create a bridge table and set the relationship direction to single.. Using a bridge table with a CROSSFILTER function or setting the relationship to single direction can resolve ambiguity. However, the recommended approach is to use a bridge table and set the relationship to single direction with 'Apply security filter in both directions' disabled.

Answer

Use the USERELATIONSHIP function in the measure.

Answer

Use the CROSSFILTER function to set both directions.

Answer

Change the relationship to one-to-many using a calculated column.