PL-300 Practice Exam 1 — 20 Questions

Question 1

You are developing a Power BI report to analyze sales performance. The data model includes a 'Sales' fact table with a 'Date' column and a 'Region' dimension table. You need to create a measure that calculates the total sales amount for the current year compared to the previous year. Which TWO of the following steps are required to implement this calculation correctly?

Accepted Answer

Create a separate date table and mark it as a date table in Power BI.. Option B is correct because a dedicated date table marked as a date table in Power BI is required for time intelligence functions like SAMEPERIODLASTYEAR to work correctly. Time intelligence functions rely on a continuous, contiguous date range with a 'Date' column marked as the date table, ensuring accurate year-over-year comparisons. Without this, the functions may return incorrect or blank results due to gaps or non-standard date hierarchies.

Answer

Use the Quick Measure feature to create a 'Year-over-year change' measure.

Answer

Apply the CALCULATE function to switch between years.

Answer

Ensure the 'Sales' table has a relationship to the 'Date' table with a many-to-many cardinality.

Question 2

A company has a Power BI dataset that includes a table 'Orders' with columns: OrderID, CustomerID, OrderDate, ShipDate, and Amount. They want to create a measure that calculates the number of orders shipped within 3 days of the order date. Which THREE of the following steps are necessary to create this measure?

Accepted Answer

Use FILTER to filter the Orders table based on the condition.. Option A is correct because FILTER is necessary to iterate over the Orders table and apply a row-by-row condition to identify orders shipped within 3 days. In DAX, FILTER returns a table that can be used as a filter argument inside CALCULATE, enabling context transition and dynamic filtering. Without FILTER, you cannot evaluate the date difference condition for each row individually.

Answer

Use COUNTROWS without any filter.

Answer

Use SUM to add up the Amount column.

Question 3

A company has a Power BI report that uses a DirectQuery dataset from an Azure SQL Database. Users report that the report is slow when filtering by date. Which action should you take to improve performance?

Accepted Answer

Create a separate date dimension table and relate it to the fact table. Creating a separate date dimension table and relating it to the fact table improves performance by enabling star schema design, which optimizes DirectQuery queries. Without a dedicated date table, Power BI may generate inefficient queries that scan the entire fact table for date filtering. A date dimension also supports time intelligence functions and reduces query complexity by allowing the database to use indexes on the date key.

Answer

Increase the date range filter to include more data

Answer

Disable cross-filtering in the report

Answer

Remove unnecessary columns from the date table

Question 4

A Power BI report contains a table visual that displays employee names and their total sales. The data model includes an Employee table with columns: EmployeeID, Name, Department, and HireDate. The Sales table has columns: SaleID, EmployeeID, Amount, and SaleDate. The relationship between Employee and Sales is one-to-many. The user wants to see only employees who have made at least one sale. However, the table shows all employees, including those with no sales (blank Amount). What is the most likely reason?

Accepted Answer

There is no visual-level filter to exclude blank values.. Option D is correct because the table visual is showing all employees due to the absence of a visual-level filter to exclude blank or zero sales amounts. In Power BI, a one-to-many relationship between Employee and Sales means that employees without sales will still appear in the visual unless explicitly filtered out, as the relationship does not automatically suppress rows from the 'one' side when there are no matching rows on the 'many' side.

Answer

The EmployeeID column in the Employee table is hidden.

Answer

The relationship is many-to-one, not one-to-many.

Answer

The relationship direction is set to Single from Employee to Sales.

Question 5

A data analyst creates a Power BI report that uses a date table with a continuous date range. They want to calculate the running total of sales over the last 12 months, ending on the last date in the current filter context. Which DAX expression should they use?

Accepted Answer

CALCULATE(SUM(Sales[Amount]), DATESBETWEEN('Date'[Date], MAX('Date'[Date]) - 365, MAX('Date'[Date]))). Option A is correct because it uses DATESBETWEEN to define a custom date range from 365 days before the last date in the current filter context (MAX('Date'[Date])) up to that last date, effectively creating a rolling 12-month window. This approach works with a continuous date table and respects the filter context, ensuring the running total is calculated dynamically based on the latest visible date.

Answer

CALCULATE(SUM(Sales[Amount]), DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -12, MONTH))

Answer

TOTALMTD(SUM(Sales[Amount]), 'Date'[Date])

Answer

CALCULATE(SUM(Sales[Amount]), DATESYTD('Date'[Date]))

Question 6

Which TWO of the following are valid ways to create a measure in Power BI?

Accepted Answer

From the Modeling tab, click New Measure.. Option A is correct because the Modeling tab in Power BI Desktop provides a dedicated 'New Measure' button that allows users to create calculated measures using DAX (Data Analysis Expressions). This is the primary and most direct method for adding measures to your data model, enabling dynamic aggregations and calculations that are not stored in the table but computed at query time.

Answer

From the Format pane, add a measure.

Answer

From Power Query Editor, add a custom column.

Answer

From the Visualizations pane, click New Measure.

Question 7

A user reports that a Power BI report is not refreshing data from a SQL Server database. The dataset uses Import mode. The gateway cluster shows all gateways are online. What is the most likely cause?

Accepted Answer

The data source credentials are incorrect or expired.. Option D is correct because in Import mode, Power BI caches data and refreshes it on a schedule using stored credentials. If those credentials expire or become invalid, the refresh fails even though the gateway cluster shows as online. The gateway being online only indicates network connectivity, not that the stored credentials are still valid for the SQL Server database.

Answer

The report is using a scheduled refresh with a conflicting time.

Answer

The gateway version is incompatible with the SQL Server version.

Answer

The dataset uses DirectQuery mode which requires a live connection.

Question 8

You need to deploy a Power BI report from a development workspace to a production workspace. You want to ensure that the report uses the production dataset connection string without manual changes. What should you use?

Accepted Answer

Configure a deployment pipeline with parameter rules to override the data source.. Option C is correct because deployment pipelines in Power BI allow you to define parameter rules that automatically override data source connection strings when content is deployed from development to production. This ensures the report uses the production dataset without any manual post-deployment changes, maintaining consistency and reducing human error.

Answer

Manually update the data source in the production workspace after deployment.

Answer

Use a Power BI template (.pbit) and change the connection string before publishing.

Answer

Publish the report directly to the production workspace and update the dataset.

Question 9

You manage a Power BI deployment that uses deployment pipelines. After promoting content from Development to Test, you notice that the Test workspace dataset uses a different data source than expected. What is the most likely reason?

Accepted Answer

The dataset parameters were not configured in the deployment pipeline rules.. Option C is correct because deployment pipeline rules allow you to configure dataset parameters (such as data source paths) to differ between pipeline stages. If these rules are not set, the dataset retains the data source configuration from the source stage (Development), causing the Test workspace to use an unexpected data source. The pipeline deploys the dataset artifact, but without parameter overrides, the data source connection string remains unchanged.

Answer

The pipeline didn't deploy the dataset because it was already in Test.

Answer

The data source credentials were not applied during deployment.

Answer

The Test workspace has a separate dataset that was manually created.

Question 10

You are deploying a Power BI solution to a customer. The customer requires that all report access be controlled via Azure Active Directory (Azure AD) groups. You have a single workspace with multiple reports. What is the best practice for managing permissions?

Accepted Answer

Add an Azure AD group to the workspace role.. Option D is correct because using an Azure AD group to manage workspace roles aligns with the customer's requirement for centralized access control via Azure AD. This approach simplifies permission management by allowing group membership changes in Azure AD to automatically propagate to Power BI workspace access, ensuring consistency and reducing administrative overhead.

Answer

Create a Power BI group and add users to it.

Answer

Assign each user directly to the workspace role.

Answer

Share each report individually with users.

Question 11

You manage a Power BI workspace that contains a dataset refreshed daily from an on-premises SQL Server. Users report that the report shows data from two days ago. You verify that the scheduled refresh ran successfully this morning. What is the most likely cause?

Accepted Answer

The gateway is using a cached version of the data due to a misconfigured data source.. Option A is correct because the most likely cause is that the on-premises data gateway is using a cached version of the data due to a misconfigured data source. When the data source is misconfigured (e.g., incorrect credentials or connection string), the gateway may fall back to a previously cached dataset, causing the report to show stale data even though the scheduled refresh appears to have run successfully. This explains why users see data from two days ago despite a successful refresh this morning.

Answer

The refresh took longer than expected and timed out.

Answer

The scheduled refresh is not set to refresh the dataset.

Answer

The on-premises data gateway is offline.

Question 12

Which TWO actions should you take to ensure that a Power BI report deployed to production is available to users even if the gateway is offline for maintenance?

Accepted Answer

Create a separate dataset in the cloud that caches the data.. Option D is correct because creating a separate dataset in the cloud that caches the data (e.g., using a scheduled dataflow or a cloud-based dataset with Import mode) ensures that the report can still serve cached data from the Power BI service even when the on-premises gateway is offline for maintenance. This decouples report availability from gateway connectivity, as long as the cached data is refreshed before the maintenance window.

Answer

Create a Power BI Premium capacity to ensure high availability.

Answer

Schedule the dataset refresh to run during the maintenance window.

Answer

Use DirectQuery instead of Import mode to avoid gateway dependency.

Question 13

Which THREE steps should you perform to deploy a Power BI solution from development to production using deployment pipelines?

Accepted Answer

Set up deployment pipeline rules to modify parameters (e.g., database name).. Option B is correct because deployment pipeline rules allow you to modify dataset parameters (e.g., database server or database name) when content moves between pipeline stages, ensuring each stage connects to the appropriate data source without manual reconfiguration. This is a core feature of Power BI deployment pipelines to maintain environment-specific settings.

Answer

Create a new workspace manually in production.

Answer

Assign Power BI Pro licenses to all developers.

Question 14

Your Power BI dataset uses DirectQuery to an Azure SQL Database. Users complain that the report is slow. You need to improve query performance without changing the data source. What should you do?

Accepted Answer

Reduce the number of columns and rows retrieved by the report visuals.. Option A is correct because reducing the number of columns and rows retrieved by report visuals directly minimizes the amount of data sent from Azure SQL Database to Power BI via DirectQuery. Since DirectQuery sends native queries to the source for each visual interaction, fewer columns and rows mean smaller, faster queries, which reduces overall latency without altering the underlying data source.

Answer

Add more visuals to the report to distribute the load.

Answer

Switch the dataset to Import mode.

Answer

Increase the scheduled refresh frequency.

Question 15

You deploy a Power BI app to a workspace with an app-only license (Premium Per User). Users report that they can access the app but cannot see any visuals in the reports. The dataset uses Import mode. What is the most likely issue?

Accepted Answer

The users do not have a Premium Per User license assigned.. The workspace uses a Premium Per User (PPU) license, which requires each user accessing content in that workspace to have a PPU license assigned. Without it, users can see the app in the list but cannot render visuals because the dataset (Import mode) is processed on PPU-capacity nodes that enforce license checks. This is the most likely cause given the symptom of empty visuals.

Answer

The report uses DirectQuery and the data source is offline.

Answer

The report is published to a shared dataset that has been deleted.

Answer

The dataset has row-level security (RLS) that filters all rows for these users.

Question 16

Which THREE factors should you consider when planning the deployment of Power BI content to a large enterprise with multiple regions?

Accepted Answer

Data residency requirements for each region.. Data residency requirements are critical because Power BI stores data in specific Azure regions. For a multi-region enterprise, you must ensure that data does not leave the required geographic boundary due to compliance or legal mandates. This affects where you provision Power BI tenants, capacity, and data sources.

Answer

The number of visuals per report page.

Answer

The currency format used in reports for each region.

Question 17

You review the dataset refresh history. The second refresh took 30 minutes and failed. What is the most likely reason for the failure?

Accepted Answer

The refresh exceeded the timeout limit set in the gateway.. The second refresh took 30 minutes and failed, which strongly indicates the refresh exceeded the default 30-minute timeout limit configured in the on-premises data gateway. When a dataset refresh operation in Power BI runs longer than the gateway's timeout setting, the gateway terminates the connection, causing the refresh to fail. This is a common issue when refreshing large datasets or complex queries through a gateway.

Answer

The refresh schedule conflicted with another refresh.

Answer

The on-premises data gateway was offline.

Answer

The data source was unavailable.

Question 18

You need to ensure that a Power BI report uses the latest data from a cloud-based Azure SQL Database. The report is configured with scheduled refresh. What is the minimum required license for the dataset owner to configure a scheduled refresh?

Accepted Answer

Power BI Pro. Option D is correct because Power BI Pro is the minimum license required for a dataset owner to configure a scheduled refresh against a cloud-based Azure SQL Database. Scheduled refresh is a premium feature that is not available with a Power BI Free license, and while Power BI Premium capacity or Premium Per User can also support scheduled refresh, they are not the minimum requirement. The dataset owner must have a Pro license to schedule refreshes for datasets hosted in shared capacity.

Answer

Power BI Premium capacity

Answer

Power BI Premium Per User

Answer

Power BI Free

Question 19

You manage a Power BI workspace used by the sales team. After updating a dataset with new columns, some users report that their reports show old data. You verify that the scheduled refresh completed successfully. What should you do first?

Accepted Answer

Open the report in Power BI Desktop, refresh the dataset, and republish.. Option A is correct because when a dataset is updated with new columns in Power BI Desktop, the report's underlying data model must be refreshed and republished to the Power BI service. Even if the scheduled refresh completes successfully, it only refreshes the existing data structure; it does not automatically incorporate schema changes like new columns. Republishing the .pbix file ensures the service has the updated metadata and data.

Answer

Clear the users' browser cache.

Answer

Reconfigure the scheduled refresh to run more frequently.

Answer

Reset the on-premises data gateway.

Question 20

You are troubleshooting connectivity to a Power BI Premium dataset via the XMLA endpoint. A user reports that they cannot connect using SQL Server Management Studio (SSMS) but can view reports in the Power BI service. The user's email is user3@contoso.com. What is the most likely cause?

Accepted Answer

The user is not in the allowedUsers list for the XMLA endpoint.. Option C is correct because the XMLA endpoint for Power BI Premium datasets requires explicit user membership in the allowedUsers list (or allowedGroups) to enable client tools like SSMS to connect. The user can view reports in the Power BI service, which uses a different permission model (workspace roles), but SSMS connectivity via XMLA is gated by this separate list. Since the user is not in the allowedUsers list, the connection fails even though they have report viewing access.

Answer

External connections are blocked by the configuration.

Answer

The user does not have permission to view reports.

Answer

The XMLA endpoint is disabled.