PL-300 Practice Test 28 — 15 Questions

Question 1

Your organization is deploying Power BI content to multiple stages (dev, test, prod) using deployment pipelines. You need to ensure that test data is not visible to production users. What is the best approach?

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

Accepted Answer

Use deployment pipelines with separate datasets per stage and configure data source parameters to point to different databases.. Option D is correct because deployment pipelines support deployment rules that let you bind each stage's dataset to a different data source via parameters, so the production stage connects to the production database and never exposes test data. Configuring data source parameters per stage is the standard mechanism for environment-specific connections in Power BI deployment pipelines. Option A is wrong because manually swapping datasets after deployment is error-prone and not a pipeline feature. Option B is wrong because row-level security filters rows for users, not test versus production data sources, and would still leave test data in the production dataset. Option C is wrong because separate tenants per stage is an extreme, costly approach that deployment pipelines are specifically designed to avoid.

Answer

Manually replace the dataset in the production workspace after deployment.

Answer

Apply row-level security to filter test data in production.

Answer

Create separate Power BI tenants for each stage.

Question 2

Which TWO of the following are valid reasons to use a calculated table in Power BI instead of a table from the source?

Accepted Answer

To create a bridge table for many-to-many relationships. Option A is correct because a calculated table can be built with DAX (e.g., DISTINCT or SUMMARIZE over the two related tables) to produce a bridge table that resolves a many-to-many relationship, something a raw source table cannot do without additional modeling. Option C is correct because a calculated table can be generated with DAX functions like CALENDAR or CALENDARAUTO to create a dedicated date table, which is required for time intelligence functions such as TOTALYTD and SAMEPERIODLASTYEAR. Option B is not a valid reason because aggregation before loading is performed in Power Query or at the source, not by a calculated table, which is computed after data is loaded into the model. Option D is not valid because incremental refresh is configured on the table's refresh policy and requires a source-side filter, not a calculated table. Option E is not valid because calculated tables are materialized in memory and typically increase, rather than reduce, the model's storage size.

Answer

To aggregate data from the source before loading

Answer

To enable incremental data refresh

Answer

To reduce the overall storage size of the model

Question 3

You need to create a visual that shows the contribution of each product category to total sales over time. Which visual type is most appropriate?

Accepted Answer

Stacked area chart. The stacked area chart (option B) is correct because it plots each product category as a cumulative band whose thickness represents that category's contribution to total sales, while the total height of the stack shows overall sales across the time axis. This makes it ideal for showing both part-to-whole composition and trends over time simultaneously. A waterfall chart (A) is designed for showing incremental positive and negative changes leading to a final total, not continuous category contributions over time. A pie chart (C) shows proportions at a single point in time and cannot represent a time series. A scatter plot (D) displays the relationship between two numeric variables as individual points, not compositional contributions over time.

Answer

Waterfall chart

Answer

Pie chart

Answer

Scatter plot

Question 4

You are designing a Power BI report page. Which two actions can you take to improve the accessibility of the report?

Accepted Answer

Add data labels to visuals. Option C is correct because adding data labels to visuals makes the underlying values directly readable on the canvas, so users who rely on screen readers or who cannot hover over data points can still access the exact numbers without needing tooltips or mouse interaction. Option D is correct because using a high-contrast theme improves readability for users with low vision or color-vision deficiencies by ensuring foreground text and visual elements stand out clearly against the background, meeting accessibility contrast guidelines. Option A is not correct because a dark background with light text is not inherently more accessible and can actually reduce readability for some users if contrast is insufficient or if it causes glare. Option B is not correct because images are not inherently inaccessible; they can be made accessible with alt text and are often useful in visuals, so avoiding them entirely is not a valid accessibility improvement. Option E is not correct because removing all tooltips reduces the information available to users rather than improving accessibility; tooltips should be retained and made keyboard-accessible instead.

Answer

Use a dark background with light text

Answer

Avoid using images in visuals

Answer

Remove all tooltips to reduce clutter

Question 5

You are working on a Power BI report for a marketing team. The report includes a page with a line chart showing website visits over time, and a table showing the top 5 marketing campaigns by conversion rate. The marketing manager wants to be able to click on a point in the line chart (representing a specific date) and have the table update to show only campaigns that were active on that date. The campaigns data includes a 'StartDate' and 'EndDate'. You have implemented a measure to filter campaigns based on the selected date. However, when you click on a date point in the line chart, the table does not update. What should you do to enable this interaction?

Accepted Answer

In the 'Edit interactions' settings, ensure that the line chart cross-filters the table.. The correct option is D: in the 'Edit interactions' settings, ensure that the line chart cross-filters the table. By default, a visual can filter other visuals on the same page, but if the interaction has been set to None (or Highlight instead of Filter), clicking a date point will not filter the table; setting the line chart to cross-filter the table restores the expected behavior so the measure evaluating StartDate/EndDate against the selected date returns only active campaigns. Option A is wrong because disabling cross-filtering would prevent the table from updating at all. Option B is wrong because drillthrough navigates to a separate drillthrough page rather than filtering the existing table on the same page. Option C is wrong because bookmarks capture static visual states and are not the mechanism for dynamic cross-filtering based on a selected data point.

Answer

In the 'Edit interactions' settings, disable cross-filtering between the line chart and table.

Answer

Create a drillthrough page and configure the line chart to drill through to the table page.

Answer

Add a bookmark for each date and set the line chart to trigger the bookmark on click.

Question 6

You have a report that uses a custom visual from AppSource. The visual is not rendering correctly after a Power BI Desktop update. What is the best course of action?

Accepted Answer

Check for an updated version of the custom visual from the developer.. The correct option is C: check for an updated version of the custom visual from the developer. Custom visuals from AppSource are third-party components that can break when Power BI Desktop updates change the underlying rendering APIs, so the developer typically publishes a compatible update that resolves the rendering issue. Option A is not a real Power BI feature for custom visuals, and compatibility mode applies to semantic model/version settings, not to fixing a broken visual. Option B would discard the intended custom functionality rather than fix it, and option D merely re-adds the same outdated version, so the problem would persist.

Answer

Enable compatibility mode for the visual.

Answer

Replace the custom visual with a built-in visual.

Answer

Remove the visual and add it again from the marketplace.

Question 7

A user reports that they cannot publish a Power BI Desktop file to the Power BI service. The error message indicates insufficient permissions. The user is a member of a workspace and has the Viewer role. What is the most likely cause?

Accepted Answer

The user has the Viewer role in the workspace. The correct answer is A: the user has the Viewer role in the workspace. In Power BI, the Viewer role only allows viewing and interacting with existing content; it does not grant permission to publish or import .pbix files into the workspace, which requires at least the Contributor role. That directly matches the reported 'insufficient permissions' error when attempting to publish from Power BI Desktop. Option B is incorrect because RLS filters data rows for viewers and would not block publishing. Option C is not the most likely cause, since a Pro license is needed to publish to shared workspaces but the error specifically points to workspace role permissions. Option D is unrelated, as the .pbix file's storage location does not determine Power BI service publishing rights.

Answer

Row-level security (RLS) is preventing the user from seeing the data

Answer

The user does not have a Power BI Pro license

Answer

The .pbix file is stored on a network share that restricts write access

Question 8

You are a Power BI developer for a financial services company. The company has a large transactional database in Azure Synapse Analytics. The database contains a table 'Transactions' with 2 billion rows. The table includes columns: TransactionID, AccountID, TransactionDate, Amount, Type (Deposit/Withdrawal), Status (Pending/Completed). You need to build a Power BI semantic model that allows executives to analyze monthly trends of completed deposit amounts by account type (e.g., Savings, Checking). The account type is in a separate 'Accounts' table (1 million rows) with columns: AccountID, AccountType, CustomerID. The model must refresh within 2 hours. Due to the large data volume, you cannot import the entire Transactions table. What should you do?

Accepted Answer

Create an aggregated table in Synapse that pre-aggregates data at the month and account type level, then use DirectQuery on the aggregated table, and use a composite model with the detail table for drill-through.. Option D is correct because it pre-aggregates the 2 billion-row Transactions table in Synapse at the month and account type grain, which drastically reduces the data volume Power BI must query, and then uses DirectQuery on that small aggregated table so refreshes complete well within the 2-hour window; the composite model with the detail table preserves drill-through to transaction-level detail when needed. Option A is wrong because mixing incremental refresh (Import) with DirectQuery for older data still requires importing large volumes and does not aggregate the 2 billion rows, so it will not reliably meet the 2-hour refresh. Option B is wrong because Power BI aggregations still depend on importing or querying the underlying detail, and importing only necessary columns from 2 billion rows remains too large for the refresh SLA. Option C is wrong because DirectQuery over the full 2 billion-row Transactions table pushes all aggregation work to Synapse at query time, producing slow executive reports and no pre-aggregation benefit.

Answer

Use incremental refresh to import only recent data, and use DirectQuery for older data.

Answer

Import only the necessary columns and use Power BI aggregations to pre-aggregate.

Answer

Use DirectQuery on the full Transactions table and rely on the Synapse query optimizer.

Question 9

A Power BI administrator needs to ensure that all reports in a workspace are labeled with a sensitivity label automatically when created. The workspace is used by multiple departments. What should the administrator configure?

Accepted Answer

Set a default sensitivity label for the workspace in the workspace settings.. The correct option is A: setting a default sensitivity label for the workspace in the workspace settings. In Power BI, a workspace admin can assign a default sensitivity label at the workspace level, so any new report or dataset created in that workspace automatically inherits that label without user action, which fits the requirement that all reports be labeled automatically on creation. Option B does not fit because Microsoft Purview auto-labeling policies apply to supported workloads like Exchange, SharePoint, and OneDrive, not directly to Power BI workspace-created items. Option C is incorrect because a tenant-wide default label is not the mechanism for per-workspace automatic labeling of new reports. Option D is incorrect because manual labeling by users is not automatic and would not guarantee consistent labeling.

Answer

Configure a Microsoft Purview auto-labeling policy for the workspace.

Answer

Set the default sensitivity label for the entire Power BI tenant.

Answer

Instruct all users to manually apply the sensitivity label when creating reports.

Question 10

You are optimizing a DAX query that returns product-country combinations with total sales over 10,000. The query runs slowly. What is the primary performance issue with this query?

Accepted Answer

Using SUMMARIZE instead of SUMMARIZECOLUMNS causes inefficient grouping and measure evaluation.. The primary issue is that the query uses SUMMARIZE to group product-country combinations and evaluate the [Total Sales] measure, which is inefficient because SUMMARIZE was not designed for measure evaluation and can produce incorrect or slow results in this pattern. SUMMARIZECOLUMNS is the optimized function for this scenario, as it is specifically engineered for grouping and evaluating measures efficiently in DAX queries. The other options do not fit: SUMX is not inherently slow and is often the correct iterator for row-by-row aggregation, FILTER is not the bottleneck here and CALCULATETABLE would not address the grouping inefficiency, and missing relationships would typically cause errors or blank results rather than merely slow performance.

Answer

The measure [Total Sales] is defined using SUMX which is slow.

Answer

The FILTER function should be replaced with CALCULATETABLE for better performance.

Answer

The query lacks proper relationships between tables, causing cross joins.

Question 11

You are importing data from a CSV file into Power BI. The file contains a column 'SalesAmount' with values like '1,234.56' and '(987.65)' for negative amounts. You need to transform this column into a decimal number. Which sequence of Power Query steps achieves this?

Accepted Answer

Replace Values ('(' with '-'), Replace Values (')' with ''), Replace Values (',' with ''), then Change Type to Decimal. It first replaces the opening parenthesis '(' with a minus sign '-', then removes the closing parenthesis ')', then removes the comma thousands separator ',', and finally changes the data type to Decimal. This sequence ensures that the negative indicator is properly placed before the numeric value and that the string is cleanly formatted for type conversion.

Answer

Change Type to Decimal, then Replace Values (',' with ''), then Replace Values ('(' with '-')

Answer

Replace Values (',' with ''), then Replace Values ('(' with '-'), then Replace Values (')' with ''), then Change Type to Decimal

Answer

Replace Values (',' with ''), Change Type to Decimal, then Replace Values ('(' with '-')

Question 12

You are a Power BI administrator. The company has a premium capacity that many users publish reports to. Recently, users have reported that some reports are slow to load. You suspect that the capacity is being overused by certain large datasets. You need to identify which workspaces and datasets are consuming the most memory and CPU resources on the capacity. You want to use a tool that provides historical metrics and can be queried. What should you do?

Accepted Answer

Install the Power BI Premium Capacity Metrics app from AppSource.. The Power BI Premium Capacity Metrics app (option A) is the correct tool because it is installed from AppSource and provides historical, queryable metrics on memory and CPU consumption per workspace and dataset on a Premium capacity, directly addressing the need to find the top resource consumers. It surfaces dataset sizes, refresh durations, CPU usage, and memory usage over time, which is exactly what the administrator requires. Option B, Performance Analyzer, only measures rendering and query performance of individual reports in Power BI Desktop and does not give capacity-wide historical resource metrics. Option C, the admin portal, shows current capacity health and utilization but not the detailed historical, queryable per-dataset metrics needed. Option D, activity logs in Log Analytics, capture user and admin activity events, not the granular memory and CPU consumption metrics of datasets on the capacity.

Answer

Use Performance Analyzer in Power BI Desktop for each report.

Answer

Use the Power BI admin portal to view capacity metrics in real-time.

Answer

Enable Power BI activity logs and query Log Analytics for capacity metrics.

Question 13

A company has a dataset with a table 'Orders' containing columns: OrderDate, CustomerID, Amount. They want to create a visual that shows the total amount per month. Which of the following is the best approach?

Accepted Answer

Create a line chart with OrderDate on the axis and use the date hierarchy to drill down to month.. It leverages Power BI's built-in date hierarchy, which automatically groups OrderDate by year, quarter, month, and day. By placing OrderDate on the axis of a line chart and drilling down to the month level, you get an accurate monthly aggregation of Amount without needing any manual data transformation or calculated columns. This approach is efficient, maintains the underlying data model's integrity, and allows for easy drill-up/drill-down navigation.

Answer

Create a pie chart with OrderDate as the legend.

Answer

Create a table visual with OrderDate and Amount, then group by month in the visual.

Answer

Create a bar chart with a calculated column 'Month' extracted from OrderDate and use that as the axis.

Question 14

Which THREE of the following are valid reasons to create a calculated table in Power BI?

Accepted Answer

To create a date table that is not available in the data source.. Option C is correct because calculated tables are commonly used to generate a date table with DAX functions like CALENDAR or CALENDARAUTO when no date dimension exists in the source, enabling time intelligence. Option D is correct because calculated tables can create disconnected tables (e.g., via GENERATESERIES or DATATABLE) that serve as slicers or inputs for what-if parameters, which have no relationship to the model. Option E is correct because calculated tables can materialize pre-aggregated summaries using SUMMARIZE or GROUPBY, reducing query-time computation and improving report performance. Option A is not a valid reason because adding a computed column to an existing table is done with a calculated column, not a calculated table. Option B is not a valid reason because merging columns from one table into another is accomplished in Power Query (Merge Queries) or via relationships, not by creating a calculated table.

Answer

To add a column that computes a value based on other columns in the same table.

Answer

To combine two tables by merging columns from one table into another.

Question 15

You have a Power BI dataset that includes a date table created using CALENDAR(). You need to ensure that the date table always covers the full range of dates present in the fact table, even after new data is loaded. What should you do?

Accepted Answer

Create the date table using CALENDAR(MIN('Fact'[Date]), MAX('Fact'[Date])). Using `CALENDAR(MIN('Fact'[Date]), MAX('Fact'[Date]))` dynamically computes the date range from the fact table's actual data. This ensures that when new data is loaded with dates outside the previous range, the date table automatically expands to cover the full range, maintaining referential integrity for time intelligence calculations.

Answer

Use a fixed start and end date in the CALENDAR function

Answer

Create a disconnected date table

Answer

Enable Auto Date/Time in the model