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

Question 1

You are creating a Power BI report and need to visualize the relationship between two numerical variables, such as sales amount and profit. Which visual type is most appropriate?

Accepted Answer

Scatter chart. Option A is correct because a scatter chart is designed to show the relationship between two numerical variables. Option B is wrong because a pie chart shows proportions of a whole. Option C is wrong because a stacked bar chart compares parts of a whole across categories. Option D is wrong because a line chart shows trends over time.

Answer

Line chart

Answer

Stacked bar chart

Answer

Pie chart

Question 2

You have a Power BI report with a page that contains a matrix visual showing sales by year and quarter. Users want to be able to drill down from year to quarter and then drill up again. The matrix currently shows only year. What should you configure?

Accepted Answer

Add both Year and Quarter fields to the matrix rows and enable drill-down mode.. Option C is correct because enabling the drill-down mode and adding both Year and Quarter to the matrix rows allows users to drill down and up. Option A is wrong because enabling drill-down without adding Quarter to the rows won't allow drill-down. Option B is wrong because adding a drillthrough page is for navigating to a detail page, not for drilling down in the same visual. Option D is wrong because adding a hierarchy to the columns would affect column drill-down, not row drill-down.

Answer

Add a hierarchy to the matrix columns.

Answer

Enable the drill-down mode on the matrix visual.

Answer

Add a drillthrough page that filters by year.

Question 3

You have a Power BI dataset that contains a table with sales data and a separate date table. You need to create a measure that calculates the total sales for the previous month relative to the selected date. Which DAX function should you use?

Accepted Answer

PREVIOUSMONTH. Option B is correct because PREVIOUSMONTH returns the previous month based on the current filter context. Option A is wrong because DATEADD shifts dates by an interval but requires a number. Option C is wrong because PARALLELPERIOD returns a parallel period, not specifically previous month. Option D is wrong because SAMEPERIODLASTYEAR returns the same period last year.

Answer

SAMEPERIODLASTYEAR

Answer

DATEADD

Answer

PARALLELPERIOD

Question 4

You have a Power BI report that includes a slicer for product category. Users want to select multiple categories and see the combined data. The slicer currently allows only single selection. What should you change?

Accepted Answer

Enable multi-select in the slicer formatting options.. Option B is correct because enabling multi-select on the slicer allows users to select multiple items. Option A is wrong because the sync slicer pane is for syncing slicers across pages. Option C is wrong because changing the slicer to dropdown does not enable multi-select by default. Option D is wrong because adding a second slicer would not solve the single-select limitation.

Answer

Change the slicer style to dropdown.

Answer

Use the sync slicer pane to replicate the slicer on other pages.

Answer

Add a second slicer for product category.

Question 5

You have a Power BI report that uses a composite model with a DirectQuery source from Azure SQL Database and an imported table from Excel. You need to ensure that when a user filters the imported table, the DirectQuery table is also filtered accordingly. What should you configure?

Accepted Answer

Set the relationship direction to filter the DirectQuery table from the imported table.. Option D is correct because setting a relationship between the DirectQuery table and the imported table, with the imported table as the filter direction, allows filtering across storage modes. Option A is wrong because a calculated column in the DirectQuery table would not automatically filter based on the imported table. Option B is wrong because enabling bidirectional cross-filtering on relationships between DirectQuery and imported tables is not supported in composite models. Option C is wrong because merging tables would change the data model and may not be necessary.

Answer

Merge the imported table into the DirectQuery source.

Answer

Enable bidirectional cross-filtering on the relationship between the tables.

Answer

Create a calculated column in the DirectQuery table that references the imported table.

Question 6

You are designing a Power BI report to analyze sales performance across multiple regions. The data includes a Date table with a Many-to-One relationship to Sales. You need to ensure that users can drill down from Year to Quarter to Month in a matrix visual. What must you configure on the Date table?

Accepted Answer

Mark the Date table as a date table. Option B is correct because enabling 'Mark as Date Table' in Power BI automatically creates hierarchies and enables drill-down capabilities. Option A is wrong because relationships do not create hierarchies. Option C is wrong because calculated columns are not required for drill-down. Option D is wrong because the built-in date hierarchy is automatically created when the table is marked as a date table.

Answer

Use the built-in date hierarchy without marking the table

Answer

Create a relationship between Date and Sales on the Date column

Answer

Add calculated columns for Year, Quarter, and Month

Question 7

You have a Power BI report that uses DirectQuery to a SQL Server database. Users report that the report is slow when filtering by a slicer on a large dimension table. You need to improve performance without changing the data source. Which approach should you take?

Accepted Answer

Set 'Assume Referential Integrity' on the relationship between tables. Option C is correct because setting 'Assume Referential Integrity' allows Power BI to use more efficient queries (INNER JOIN instead of OUTER JOIN) when filtering, which improves performance. Option A is wrong because aggregations are not supported in DirectQuery for this scenario. Option B is wrong because reducing cardinality may affect accuracy. Option D is wrong because dual storage mode does not apply to DirectQuery sources.

Answer

Create an aggregation table on the dimension

Answer

Change the storage mode of the dimension table to Dual

Answer

Reduce the cardinality of the slicer field by grouping values

Question 8

You have a Power BI report that includes a line chart showing monthly sales. You want to add a trend line to help users identify the overall direction of sales over time. Which feature should you use?

Accepted Answer

Analytics pane in the visual. Option A is correct because the Analytics pane in line chart visuals provides the 'Trend line' option. Option B is wrong because a forecast is different from a trend line. Option C is wrong because the format pane deals with visual appearance, not analytics. Option D is wrong because DAX is not required to add a trend line.

Answer

Forecast option in the visual

Answer

Add a DAX measure for linear regression

Answer

Format pane to change line style

Question 9

You are building a Power BI report from a large dataset (10 GB) stored in Azure Synapse Analytics. The dataset includes a fact table with 500 million rows. You need to minimize the amount of data imported into Power BI while still allowing users to filter by year and product category. Which approach should you use?

Accepted Answer

Configure Incremental Refresh with a filter on year. Option D is correct because Incremental Refresh with Filtering allows you to import only relevant data (e.g., current year) and filter further by other dimensions. Option A is wrong because DirectQuery may be slow for large fact tables. Option B is wrong because aggregations are not suitable for filtering at granular level. Option C is wrong because reducing columns does not reduce rows sufficiently.

Answer

Use DirectQuery to avoid importing data

Answer

Import only the necessary columns from the fact table

Answer

Create an aggregation table on year and product category

Question 10

You are designing a Power BI dashboard for executive review. The dashboard must include a card visual showing the total sales for the current year. You need to ensure that the card visual updates automatically when data refreshes. Which TWO actions should you take?

Accepted Answer

Configure a scheduled refresh for the dataset. Options B and C are correct because setting auto-refresh and scheduling a data refresh ensure the visual updates. Option A is incorrect because manual refresh is not automatic. Option D is incorrect because DAX measures update on refresh without additional setting. Option E is incorrect because page refresh is not the same as data refresh.

Answer

Set the visual to refresh every 5 minutes

Answer

Use a measure that recalculates on every interaction

Answer

Set the report to refresh on page load

Question 11

You have a Power BI report that uses a composite model with a DirectQuery source and an imported table. Users report that some visuals show incorrect totals when using measures that reference both sources. Which THREE conditions must be met to ensure correct results?

Accepted Answer

Ensure relationships are defined with appropriate cardinality and cross-filter direction. Options A, D, and E are correct. Setting 'Assume Referential Integrity' (A) allows Power BI to optimize queries. Ensuring compatible relationships (D) is crucial for composite models. Using measures that aggregate correctly across storage modes (E) is necessary. Option B is incorrect because dual storage mode is not required. Option C is incorrect because query reduction does not fix incorrect totals.

Answer

Set both sources to Dual storage mode

Answer

Enable 'Reduce queries' in report settings

Question 12

You are creating a Power BI report to analyze customer churn. You have a table with Customer ID, Churn Date, and other attributes. You want to create a measure that calculates the number of customers who churned in the last 30 days. Which THREE components do you need?

Accepted Answer

A measure using CALCULATE, COUNTROWS, and DATESINPERIOD. Options A, B, and E are correct: a date table (A) for time intelligence, a relationship (B) between date table and churn date, and a CALCULATE measure (E) with appropriate filter. Option C is incorrect because a calculated column is not required. Option D is incorrect because a disconnected table is not necessary.

Answer

A calculated column for 30-day flag

Answer

A disconnected table with date range

Question 13

You are reviewing a DAX query that returns total sales by year and quarter. However, the result includes rows for quarters with no sales. Which modification should you make to exclude empty rows?

Accepted Answer

Add a filter: 'FILTER(ALL('Date'), NOT ISBLANK([Total Sales]))' inside SUMMARIZECOLUMNS. Option C is correct because KEEPFILTERS is not needed; SUMMARIZECOLUMNS by default only returns rows where at least one non-empty measure exists. However, if the measure is defined as a sum, it may return zero for empty combinations. To truly exclude rows where the measure is blank, you can add a filter. But the exhibit shows an implicit measure that returns blank for empty groups. SUMMARIZECOLUMNS automatically excludes rows where all measure values are blank. Since the measure is a simple SUM, it returns blank for quarters with no sales, so SUMMARIZECOLUMNS will exclude them. Option A is wrong because NATURALINNERJOIN is not needed. Option B is wrong because ADDCOLUMNS is unnecessary. Option D is wrong because the query already returns correct results.

Answer

No modification is needed; SUMMARIZECOLUMNS already excludes blank rows

Answer

Replace SUMMARIZECOLUMNS with ADDCOLUMNS(SUMMARIZE(...))

Answer

Wrap the SUMMARIZECOLUMNS in a NATURALINNERJOIN with Sales table

Question 14

You are a data analyst for a retail company with stores across 50 states. You have a Power BI dataset that imports sales data from a SQL Server database daily. The fact table contains 200 million rows and includes columns: StoreID, ProductID, DateKey, SalesAmount, Quantity, and Discount. You also have dimension tables for Store, Product, and Date. Users report that a report page with a matrix visual showing SalesAmount by Store and ProductCategory takes over 30 seconds to render. You need to improve the performance of this visual without changing the data source or reducing the data granularity. You have the following options: A. Change the matrix visual to a table visual. B. Create an aggregation table on Store and ProductCategory with pre-calculated SalesAmount. C. Enable 'Show items with no data' on the matrix. D. Use a measure that sums SalesAmount and use the 'Filter' pane to restrict to top 100 rows. Which option should you choose?

Accepted Answer

Create an aggregation table on Store and ProductCategory with pre-calculated SalesAmount. Option B is correct because creating an aggregation table at a higher granularity (Store, ProductCategory) allows Power BI to use aggregated data for the visual, drastically reducing query time. Option A is wrong because a table visual does not improve performance; it may even be slower. Option C is wrong because showing items with no data increases the number of rows displayed. Option D is wrong because filtering to top 100 rows does not address the underlying query performance; the measure still scans the entire fact table.

Answer

Change the matrix visual to a table visual

Answer

Use a measure that sums SalesAmount and use the 'Filter' pane to restrict to top 100 rows

Answer

Enable 'Show items with no data' on the matrix

Question 15

You are building a Power BI report for the HR department. You have a table 'Employees' with columns: EmployeeID, Name, Department, HireDate, Salary, and ManagerID. You need to create a hierarchy for organizational chart that allows users to drill from CEO down to individual employees. The hierarchy should be dynamic based on the ManagerID. Which approach should you use? A. Create a parent-child hierarchy using DAX PATH and PATHITEM functions. B. Create a calculated column that concatenates all manager levels. C. Use the built-in drill-down feature with a matrix visual. D. Create separate tables for each level and merge them. Which option is the best?

Accepted Answer

Create a parent-child hierarchy using DAX PATH and PATHITEM functions. Option A is correct because Power BI supports parent-child hierarchies using DAX functions like PATH and PATHITEM to create a hierarchy from a self-referencing table. Option B is wrong because concatenation does not create a hierarchy. Option C is wrong because drill-down in a matrix requires explicit hierarchy levels. Option D is wrong because creating separate tables is complex and not dynamic.

Answer

Create separate tables for each level and merge them

Answer

Use the built-in drill-down feature with a matrix visual

Answer

Create a calculated column that concatenates all manager levels