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

Question 1

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.. Option C is correct because enabling Query Reduction reduces the number of DAX queries sent to the source by combining filters and applying them in a single query. Option A is wrong because field parameters do not affect performance. Option B is wrong because it requires changing the data source to import mode. Option D is wrong because visual-level filters do not reduce query load from the source.

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 2

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.. Option B is correct because 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. Option C is wrong because bookmarks do not enable drill-down. Option D is wrong because tooltips provide additional information but do not support drill-down.

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 3

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" & FORMAT('Date'[Date], "Q", "en-US", 2025-07-01). Option A is correct because FORMAT with "Q" returns the quarter number, and the shift of 0 accounts for the fiscal year start in July (July=Q1). Option B is wrong because it returns the calendar quarter. Option C is wrong because it uses "\QQ" which is incorrect syntax. Option D is wrong because it uses QUARTER function which returns 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 4

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.. Option D is correct because replacing LOOKUPVALUE with a relationship-based approach (e.g., using RELATED) or merging tables in Power Query is more efficient. Option A is wrong because increasing RAM does not address the inefficiency of LOOKUPVALUE. Option B is wrong because disabling the query reduction setting would degrade performance. Option C is wrong because incremental refresh applies to the fact table, not to calculated columns.

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.

Question 5

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. Option A is correct because 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 6

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.. Option B is correct because COALESCE replaces blank with the next non-blank value, so if CurrentYear is blank but PreviousYear has data, it returns 0. Option A is wrong because ISBLANK would still return blank if CurrentYear is blank. Option C is wrong because it only handles division by zero. Option D is wrong because it replaces blank with 0 only for the denominator.

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 7

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.. Option B is correct because tooltips are configured by adding fields to the tooltips well. Option A is wrong because drill-through is for navigating to another page. Option C is wrong because bookmarks switch states. Option D is wrong because the tooltip is a visual property, not a page property.

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 8

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 A and D are correct. A: Using consistent color coding helps users quickly interpret data. D: Including key KPIs focuses on what matters. Option B is wrong because too many visuals clutter the dashboard. Option C is wrong because real-time refresh may not be necessary and can impact performance.

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 9

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 D are correct. A: Including a full calendar year range ensures all dates are covered. C: Marking as date table enables time intelligence functions. D: CALENDARAUTO automatically adjusts to the data range. Option B is wrong because using DISTINCT on TransactionDate may miss dates without transactions. Option E is wrong because adding columns one by one is inefficient.

Answer

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

Answer

Create each date column manually using ADDCOLUMNS.

Question 10

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 A and D are correct. A: Reducing the number of visuals decreases the number of queries sent to the source. D: Creating aggregations in the source can speed up query responses. Option B is wrong because using many calculated columns increases query complexity. Option C is wrong because disabling query reduction would increase the number of queries.

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 11

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, C, and E are correct. A: Slicers allow users to filter data interactively. C: Drill-through enables navigation to detail pages. E: Bookmarks can save and switch between views. Option B is wrong because disabling cross-filtering limits interactivity. Option D is wrong because tooltips are for additional info, not primary navigation.

Answer

Disable cross-filtering between visuals.

Answer

Use only default tooltips.

Question 12

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.. Options A and D are correct. A: RLS filters data at the row level based on the user's role. D: Role membership is managed in the Power BI service after publishing. Option B is wrong because RLS does not affect measures. Option C is wrong because RLS does not automatically filter visual titles. Option E is wrong because RLS does not affect data refresh scheduling.

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 13

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.. Option C is correct because 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 increasing RAM is a temporary fix and does not address the root cause. Option B is wrong because incremental refresh can help with load times but does not fix the profit margin issue or mobile layout. Option D is wrong because changing to DirectQuery might introduce performance issues and does not address the profit margin or mobile layout.

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 14

You have a Power BI report that shows sales by region. Users report that the map visual is not displaying data for some countries. What is the most likely cause?

Accepted Answer

The geographic data is not categorized correctly in the Data pane.. The most likely cause is that the geographic data is not categorized correctly in the Data pane. Power BI map visuals rely on the data category (e.g., Country, State, City) assigned to each field to correctly geocode and plot locations. If a field containing country names is left as 'Text' or 'Uncategorized', Power BI may fail to recognize the values as geographic entities, resulting in missing data points on the map.

Answer

The report page filter is excluding those countries.

Answer

The map visual is limited to 30 data points.

Answer

The map visual only supports US addresses.

Question 15

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

Accepted Answer

SAMEPERIODLASTYEAR. The SAMEPERIODLASTYEAR function returns a set of dates shifted one year back in time, which is exactly what you need to compare current period values with the prior year for year-over-year growth calculations. By using SAMEPERIODLASTYEAR in a measure like `DIVIDE(SUM(Sales[Amount]) - CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR('Date'[Date])), CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR('Date'[Date])))`, you get the percentage change. This function is specifically designed for year-over-year comparisons and works correctly with contiguous date ranges.

Answer

DATEADD

Answer

DATESYTD

Answer

PARALLELPERIOD