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

Question 1

You are building a report for executives to monitor key performance indicators (KPIs) against targets. You have a KPI visual for revenue. The target is stored in a separate table. Which approach should you use to configure the KPI visual correctly?

Accepted Answer

Create measures for actual and target, then assign them to the KPI visual.. Option D is correct because the KPI visual requires a single value for actual, a goal, and a trend axis. By creating measures that retrieve the target from the separate table, you can assign them to the KPI visual fields. Option A is wrong because merging tables would denormalize the model unnecessarily. Option B is wrong because the KPI visual cannot directly use a column from a related table without measures. Option C is wrong because calculated columns are static and not suitable for dynamic targets.

Answer

Create a calculated column in the sales table that references the target.

Answer

Merge the target table into the sales table in Power Query.

Answer

Use the target column directly from the related table in the KPI visual.

Question 2

You want to create a report that allows users to select a product category and see the top 5 products by sales within that category. Which approach should you use?

Accepted Answer

Add a slicer for category and apply a Top N filter on product to the visual.. Option A is correct because using the Top N filter with a slicer for category allows dynamic filtering. Option B is wrong because a static rank would not respond to slicer selection. Option C is wrong because a waterfall chart does not support Top N. Option D is wrong because calculated columns cannot be dynamic based on slicer selection.

Answer

Use a waterfall chart with category on the breakdown axis.

Answer

Use a measure to rank products and filter visual to top 5.

Answer

Create a calculated column for rank and filter to top 5.

Question 3

You have a Power BI report that uses a date hierarchy (Year, Quarter, Month) on the axis of a line chart. Users want to drill down from year to quarter to month. However, the drill-down feature is not working. What is the most likely cause?

Accepted Answer

The date field is placed in the Axis field well without creating a hierarchy.. Option C is correct because the drill-down feature requires a hierarchy in the field well. If only the date field is used without explicit hierarchy, drill-down is disabled. Option A is wrong because the line chart supports drill-down with hierarchies. Option B is wrong because cross-filtering does not disable drill-down. Option D is wrong because drill-down does not require a date table relationship.

Answer

The line chart does not support drill-down functionality.

Answer

The date table is not marked as a date table in the model.

Answer

Cross-filtering from another visual is interfering.

Question 4

You need to create a measure that calculates the total sales for the previous month, regardless of any filters on the date slicer. The data model includes a separate date table with a relationship to the sales table. Which DAX expression should you use?

Accepted Answer

CALCULATE(SUM(Sales[Amount]), PREVIOUSMONTH('Date'[Date]), ALL('Date')). Option B is correct because PREVIOUSMONTH returns the previous month based on the current filter context, but it is affected by slicer filters. To ignore slicer, you can use a combination like CALCULATE with ALL to remove filters, then use PREVIOUSMONTH. However, among given options, only B uses PREVIOUSMONTH with ALL. Option A uses DATEADD which can also work but is more complex. Option C uses DATESMTD which is month-to-date, not previous month. Option D uses a hardcoded date which is not dynamic.

Answer

CALCULATE(SUM(Sales[Amount]), DATEADD('Date'[Date], -1, MONTH))

Answer

CALCULATE(SUM(Sales[Amount]), DATESMTD(DATEADD('Date'[Date], -1, MONTH)))

Answer

CALCULATE(SUM(Sales[Amount]), 'Date'[Month] = FORMAT(TODAY()-30, 'MMMM'))

Question 5

You have a report with a map visual showing store locations by city. However, some cities are not displaying on the map. You verified that the city names are correct. What should you check first?

Accepted Answer

Add latitude and longitude fields to the map visual.. Option D is correct because Power BI map visuals require latitude and longitude coordinates for accurate placement. If only city names are provided, Power BI attempts to geocode them, which may fail for some cities. Providing coordinates ensures accuracy. Option A is wrong because built-in map visuals support city names. Option B is wrong because ArcGIS Map may also need coordinates. Option C is wrong because the field data type is not the issue.

Answer

Use ArcGIS Map visual instead of the built-in map.

Answer

Change the map visual to a filled map.

Answer

Ensure the city column is set to the Text data type.

Question 6

Which TWO measures will correctly calculate the total sales for the current year, ignoring any filters on the date column? (Assume a proper date table with relationship.)

Accepted Answer

CALCULATE(SUM(Sales[Amount]), DATESYTD('Date'[Date]), ALL('Date')). Options A and C are correct. Option A uses DATESYTD with ALL to remove date filters and compute year-to-date. Option C uses CALCULATE with a filter expression that selects all dates in the current year (using YEAR function) and ALL to ignore other filters. Option B is wrong because it uses VALUES which returns distinct years from the current filter context, not all. Option D is wrong because it sums all rows without year context. Option E is wrong because it uses FILTER incorrectly.

Answer

CALCULATE(SUM(Sales[Amount]), FILTER(ALL('Date'), YEAR('Date'[Date]) = YEAR(TODAY())))

Answer

CALCULATE(SUM(Sales[Amount]), VALUES('Date'[Year]))

Answer

SUM(Sales[Amount])

Question 7

Which THREE actions can you take to improve the performance of a slow Power BI report that uses multiple visuals on a single page?

Accepted Answer

Use the Performance Analyzer to identify and optimize the slowest visuals.. Options A, C, and E are correct. Reducing query reduction by turning off cross-filtering interactions (A) reduces query load. Reducing the number of fields in a visual (C) reduces data retrieval. Using performance analyzer to identify slow visuals (E) is a best practice. Option B is wrong because increasing data refresh frequency does not improve report rendering performance. Option D is wrong because adding more measures increases calculation load.

Answer

Increase the frequency of data refreshes to reduce data latency.

Answer

Add more calculated measures to precompute aggregations.

Question 8

Which TWO DAX functions can be used to create a dynamic title that shows the currently selected year in a report, assuming a date table with a Year column?

Accepted Answer

CONCATENATEX(VALUES('Date'[Year]), 'Date'[Year], ", "). Options A and C are correct. SELECTEDVALUE returns the single selected value from a column; if multiple values are selected, it returns blank or a default. CONCATENATEX can be used to combine multiple selected years into a string. Option B is wrong because CALCULATE does not return a text value. Option D is wrong because SUM is mathematical. Option E is wrong because DISTINCT returns a table, not a scalar.

Answer

SUM('Date'[Year])

Answer

DISTINCT('Date'[Year])

Answer

CALCULATE(VALUES('Date'[Year]))

Question 9

Which THREE steps are required to set up row-level security (RLS) in Power BI Desktop?

Accepted Answer

Use the View as Roles feature to test the security filters.. Options A, C, and E are correct. You must create roles and define DAX filters (A), then validate the roles using the 'View as' feature (C), and after publishing, assign users to roles in the Power BI service (E). Option B is wrong because RLS is defined in Desktop, not the service. Option D is wrong because RLS does not require a gateway for definition.

Answer

Install and configure an on-premises data gateway.

Answer

Publish the report to the Power BI service before defining roles.

Question 10

You are a Power BI analyst for a multinational retail company. The company's sales data is stored in an Azure SQL Database with tables: Sales (SalesID, Date, ProductID, Quantity, Amount), Products (ProductID, ProductName, Category), and Calendar (Date, Year, Month, Day). The Sales table contains 500 million rows. You are creating a Power BI report to analyze daily sales trends over the past 5 years. The report must allow users to drill from year to month to day using a hierarchy. The performance of the report is critical; users expect visuals to load within 5 seconds. The current model imports all tables without any optimization, and the date hierarchy visual takes over 30 seconds to render. You need to redesign the data model to meet the performance requirement. What should you do?

Accepted Answer

Create an aggregated table in Power Query that groups sales by date, and create a date hierarchy in the Calendar table.. Option B is correct because reducing the granularity of the Sales table by pre-aggregating daily sales reduces the number of rows drastically, improving query performance. Creating a date hierarchy in the Calendar table allows drill-down. Option A is wrong because DirectQuery may still be slow over 500 million rows without aggregation. Option C is wrong because incremental refresh only affects data load time, not query performance. Option D is wrong because calculated columns add to model size and do not help with aggregation.

Answer

Add calculated columns for Year, Month, and Day in the Sales table to avoid using the Calendar table.

Answer

Switch the import mode to DirectQuery to avoid loading all data into memory.

Answer

Implement incremental refresh policy on the Sales table to reduce the amount of data loaded.

Question 11

You are building a Power BI report for the HR department to analyze employee turnover. You have an Employee table with columns: EmployeeID, Name, Department, HireDate, TerminationDate (nullable). The report must include a measure that calculates the number of active employees as of the last day of each month. The data model also includes a Calendar table with a continuous date range. The measure must be accurate regardless of any slicer selections on the Calendar table. You need to write the DAX measure. Which measure should you use?

Accepted Answer

CALCULATE(COUNTROWS(Employee), Employee[HireDate] <= MAX('Calendar'[Date]), (Employee[TerminationDate] > MAX('Calendar'[Date]) || ISBLANK(Employee[TerminationDate]))). Option B is correct because it uses a pattern that calculates employees hired on or before the last date of the month and terminated after that date or still active (TerminationDate is blank). The use of MAX('Calendar'[Date]) ensures it respects the current filter context for the month, and the logic correctly counts active employees. Option A is wrong because it uses MIN instead of MAX, and the logic is reversed. Option C is wrong because it uses a fixed date. Option D is wrong because it sums an expression incorrectly.

Answer

CALCULATE(COUNTROWS(Employee), Employee[HireDate] <= MAX('Calendar'[Date]), Employee[TerminationDate] > MIN('Calendar'[Date]) || ISBLANK(Employee[TerminationDate]))

Answer

SUMX(Employee, IF(Employee[HireDate] <= MAX('Calendar'[Date]) && (Employee[TerminationDate] > MAX('Calendar'[Date]) || ISBLANK(Employee[TerminationDate])), 1, 0))

Answer

CALCULATE(COUNTROWS(Employee), Employee[HireDate] <= TODAY(), ISBLANK(Employee[TerminationDate]))

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 is slow to load. You need to improve performance without changing the data model. What should you do?

Accepted Answer

Implement report-level measures to pre-calculate complex aggregations.. Option A is correct because implementing report-level measures can reduce the number of queries sent to the server, improving performance. Option B is wrong because enabling 'Load to report' would import data, breaking the live connection requirement. Option C is wrong because increasing the page's visual count could degrade performance. Option D is wrong because reducing the number of relationships would alter the data model, which is not allowed.

Answer

Enable 'Load to report' on the dataset to import data into Power BI.

Answer

Reduce the number of relationships in the data model.

Answer

Increase the number of visuals on each report page to reduce the number of pages.

Question 13

You are designing a Power BI report for executive leadership. The report must display key performance indicators (KPIs) with current values and trend arrows. Which visual type should you use?

Accepted Answer

KPI visual. Option C is correct because the KPI visual is specifically designed to show a current value, a status indicator (like trend arrow), and a goal. Option A is wrong because a card visual only shows a single value without trend. Option B is wrong because a gauge visual shows progress toward a goal but not a trend arrow. Option D is wrong because a table visual is for detailed data, not KPIs.

Answer

Table visual

Answer

Card visual

Answer

Gauge visual

Question 14

You have a Power BI report that uses a DirectQuery dataset from Azure Synapse Analytics. Users complain that applying a filter on a date slicer takes over 30 seconds. The underlying table contains 500 million rows. You need to improve slicer responsiveness. What should you do?

Accepted Answer

Create a date dimension table in the source and use it for the slicer.. Option B is correct because creating a date dimension table and using it for the slicer reduces the cardinality of the filter column, improving DirectQuery performance. Option A is wrong because increasing the page's visual count would add more queries. Option C is wrong because importing the date table would create a hybrid model, but the slicer on the imported table would still need to filter the DirectQuery table, which may cause performance issues. Option D is wrong because disabling cross-filtering doesn't address the root cause.

Answer

Disable cross-filtering between the slicer and other visuals.

Answer

Add more visuals to the page so the slicer filter is reused across visuals.

Answer

Import the date column into Power BI and use it for the slicer.

Question 15

Refer to the exhibit. You have a Power BI measure defined as shown. Users report that when they filter by region, the measure always shows sales for the North region regardless of the filter. What is the most likely cause?

Accepted Answer

The filter argument in CALCULATE overrides the existing filter context on Region.. Option A is correct because the CALCULATE function includes a filter argument that overrides any existing filter context on the Region column. Option B is wrong because SUM does not ignore filters. Option C is wrong because the measure syntax is valid. Option D is wrong because the filter is on Region, not on the entire table.

Answer

The SUM function ignores filters applied to the Sales table.

Answer

The measure syntax is invalid and defaults to no filter.

Answer

The filter is applied to the entire Sales table, not just the Region column.