PL-300 Practice Test 37 — 15 Questions

Question 1

You are a Power BI data analyst for a financial services company. Your semantic model contains a fact table named Transactions with columns TransactionID, AccountID, TransactionDate, and Amount. You also have a dimension table named Accounts with AccountID, AccountType, and OpeningDate. You need to create a calculated column in the Transactions table that returns the account type for each transaction. Which DAX function should you use?

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

Accepted Answer

RELATED(Accounts[AccountType]). RELATED is the correct function to retrieve a value from the one side of a relationship in a calculated column on the many side. It uses the existing relationship between Transactions and Accounts to return the account type for each transaction. LOOKUPVALUE is a fallback when no relationship exists, while CALCULATE and USERELATIONSHIP serve different purposes.

Answer

LOOKUPVALUE(Accounts[AccountType], Accounts[AccountID], Transactions[AccountID])

Answer

USERELATIONSHIP(Accounts[AccountID], Transactions[AccountID])

Answer

CALCULATE(MAX(Accounts[AccountType]), RELATEDTABLE(Accounts))

Question 2

You are a data analyst for a manufacturing company. You have a Power BI semantic model that imports data from an Azure SQL Database. The model contains a fact table named Production and a dimension table named Products. The Products table has columns ProductID, ProductName, Category, and Subcategory. You need to reduce the model size and improve query performance. Which two actions should you take? (Choose two.)

Accepted Answer

Change the data type of ProductID from Text to Whole Number.. Removing unused columns and converting numeric keys stored as text to whole numbers both reduce the model's memory footprint and improve query performance. Unused columns add unnecessary cardinality and storage, while text columns are less efficient than numeric types. The other options either affect only metadata or increase model size.

Answer

Enable 'Auto date/time' for the Production table.

Answer

Create a hierarchy for Category and Subcategory.

Answer

Set the Category and Subcategory columns to use the 'Summarize by: Don't summarize' property.

Question 3

You are a Power BI data analyst for a healthcare organization. You build a report page containing a card visual that displays total patient admissions, a slicer for hospital department, and a table visual listing patient details. A physician selects the 'Cardiology' department in the slicer. She then notices that the card visual updates to show only Cardiology admissions, but the table visual still shows all patients from every department. She wants both visuals to respond to the slicer. What should you do?

Accepted Answer

Edit the interactions for the slicer so that the table visual is filtered by the slicer.. Slicers filter other visuals by default, but individual interactions can be disabled. The table visual's interaction with the slicer was likely set to 'None', so it displays unfiltered data. Using 'Edit interactions' to set the table to be filtered resolves the issue and ensures consistent cross-filtering across the page.

Answer

Add the Department column to the table visual's visual-level filters and set it to 'Cardiology'.

Answer

Change the slicer's selection mode to 'Single select' and enable 'Show Select All'.

Answer

Convert the table visual to a matrix and enable 'Stepped layout'.

Question 4

You are preparing data for a financial model. A column named 'Amount' arrives from a source system as text values such as '1.234,56' using a European format where the period is the thousands separator and the comma is the decimal separator. You need to convert these to numeric decimal values. The dataset must refresh without manual intervention as new rows arrive. What should you do?

Accepted Answer

Change the column data type to Decimal Number and set the locale in the Change Type step to a European locale such as German (Germany).. Setting the locale during the type change lets Power Query interpret the European number format correctly, producing accurate decimal values that persist on refresh. String replacement and default-locale conversions either corrupt values or break for edge cases, while leaving the column as text blocks numeric operations.

Answer

Use Replace Values to remove the periods, then replace the comma with a period, then change the type to Decimal Number.

Answer

Leave the column as text and create a DAX measure that uses SUBSTITUTE to convert values at query time.

Answer

Change the column data type to Decimal Number using the default English (United States) locale.

Question 5

You are a Power BI author for a marketing agency. You have a report with a pie chart showing the percentage of total leads by source. The report is shared with clients who view it on mobile devices. The pie chart's legend is taking up too much space and making the chart small. What should you do to improve the mobile experience?

Accepted Answer

In the mobile layout view, hide the legend and add a custom visual or use data labels to show percentages.. The mobile layout view in Power BI allows you to design a dedicated phone layout. Hiding the legend and using data labels to show percentages reduces clutter and maximizes the chart area. This is the most effective way to improve the pie chart's readability on mobile devices.

Answer

Change the legend position to 'Top' in the visual formatting.

Answer

Convert the pie chart to a donut chart.

Answer

Increase the size of the pie chart on the desktop layout, which will also affect mobile.

Question 6

You are a Power BI data analyst for a manufacturing company. You have a report with a scatter chart that plots production cost (X-axis) versus defect rate (Y-axis) for various production lines. You want to enable users to quickly identify production lines that have both high cost and high defect rate. You decide to add a reference line that divides the chart into quadrants. What should you do?

Accepted Answer

Add a constant line to the X-axis and a constant line to the Y-axis, setting each to the respective average values.. Scatter charts in Power BI allow constant lines on both the X and Y axes. By adding a constant line on each axis at the average values, you create a quadrant view. Points in the upper-right quadrant have both high cost and high defect rate, making them easy to spot. This is the correct approach for quadrant analysis.

Answer

Use the 'Analytics' pane to add a 'Median' line on the X-axis only.

Answer

Create a calculated column that categorizes each production line into a quadrant and use it as a legend.

Answer

Add a trend line and set it to 'Linear' to show the relationship between cost and defect rate.

Question 7

You are a Power BI data analyst for a marketing agency. You have a report page with several visuals that display campaign performance metrics. The page is getting crowded, and you need to provide users with a way to view different sets of visuals without creating multiple report pages. You decide to use bookmarks and a bookmark navigator. What should you do to ensure that users can switch between views seamlessly?

Accepted Answer

Create bookmarks for each view, and in the Selection pane, hide or show the relevant visuals before capturing each bookmark.. Bookmarks capture the current state of a report page, including visual visibility. To create different views on the same page, you hide or show visuals using the Selection pane, then create a bookmark for each configuration. The bookmark navigator provides buttons to switch between these bookmarks. Capturing data or using page navigation does not achieve the desired in-page view switching.

Answer

Use the 'Data' option in the bookmark settings to capture the current filter state for each view.

Answer

Add buttons for each view and configure them to navigate to different report pages.

Answer

Create separate bookmarks for each view, ensuring that the 'Display' option is checked for all visuals.

Question 8

You are a Power BI data analyst for a marketing agency. You create a report with a pie chart showing the percentage of total website traffic by device type (Desktop, Mobile, Tablet). A stakeholder asks you to change the chart so that it shows the actual number of sessions for each device type instead of percentages. What should you do?

Accepted Answer

In the pie chart's format settings, change the 'Detail labels' to display 'Value' instead of 'Percent of total'.. Pie charts display proportions by default, but you can change the data labels to show actual values. In the format settings for the pie chart, under 'Detail labels', you can select 'Value' instead of 'Percent of total'. This makes each slice display the number of sessions for that device type while the slice size still represents the proportion.

Answer

Convert the pie chart to a donut chart and enable 'Show values'.

Answer

Change the visual type to a stacked bar chart.

Answer

Add a card visual next to the pie chart showing the total sessions.

Question 9

You have a Power BI report with a map visual showing sales by city. You want to ensure that cities with higher sales are represented by larger bubbles. What should you do?

Accepted Answer

Place the Sales measure in the Size field well of the map visual.. To size map bubbles by a measure, you place that measure in the Size field well. The map visual then scales the bubbles according to the measure's value. This is the standard way to create proportional symbol maps in Power BI.

Answer

Create a measure that calculates the rank of each city by sales and use it as the Location field.

Answer

Place the Sales measure in the Tooltips field well of the map visual.

Answer

In the map's formatting options, set the Bubble size to 'Sales'.

Question 10

You are a Power BI administrator. You need to ensure that users in your organization can only access Power BI through the web browser and cannot use the Power BI Desktop application to connect to the Power BI service. Which tenant setting should you configure?

Accepted Answer

Disable 'Allow users to connect to the Power BI service with Power BI Desktop'.. The tenant setting 'Allow users to connect to the Power BI service with Power BI Desktop' controls whether Desktop can be used to connect to the service. Disabling it restricts users to the web browser. Other settings address different features such as publishing publicly or API access, and do not prevent Desktop connections.

Answer

Disable 'Publish to web' for the entire organization.

Answer

Disable 'Allow service principals to use Power BI APIs'.

Answer

Disable 'Allow users to try Power BI Desktop for free'.

Question 11

You are a Power BI administrator. A user reports that they cannot refresh a dataset that connects to an on-premises SQL Server using a gateway. The dataset was previously refreshing successfully. You need to ensure that the dataset can refresh again. What should you do first?

Accepted Answer

Check the gateway cluster status and ensure the gateway is online and has the latest version.. The most likely cause of a sudden refresh failure for an on-premises data source is an issue with the gateway. Checking the gateway status is the first troubleshooting step because if the gateway is offline or outdated, the refresh will fail. Other steps like re-entering credentials or increasing timeout are secondary.

Answer

Increase the dataset refresh timeout in the dataset settings.

Answer

Republish the dataset from Power BI Desktop.

Answer

Re-enter the data source credentials in the dataset settings.

Question 12

You are a Power BI administrator. You need to configure a data loss prevention (DLP) policy in Microsoft Purview to protect sensitive information in Power BI. The policy must detect and restrict sharing of reports that contain credit card numbers. Which two actions should you perform? (Choose two.)

Accepted Answer

Create a DLP policy in Microsoft Purview that applies to the Power BI workload.. To detect and restrict sharing of Power BI reports containing credit card numbers, you must create a DLP policy that applies to the Power BI workload and define rules that include a sensitive information type for credit card numbers. These two actions enable detection and enforcement. Other actions, such as enabling label application or using a gateway, do not provide DLP detection for Power BI content.

Answer

Configure a data gateway to scan Power BI datasets for sensitive data.

Answer

Enable the tenant setting 'Allow users to apply sensitivity labels to their content'.

Answer

Publish the DLP policy to all users in the organization.

Question 13

You are a Power BI administrator. Your organization uses Microsoft Purview sensitivity labels integrated with Power BI. A report author applies a sensitivity label named 'Confidential' to a Power BI dataset. Later, the author exports a Power BI report that uses this dataset to a PDF file. You need to ensure that the exported PDF file retains the same sensitivity label and protection settings as the dataset. What should you do?

Accepted Answer

Enable the tenant setting 'Apply sensitivity labels to exported data' in the Power BI admin portal.. Enabling the tenant setting 'Apply sensitivity labels to exported data' ensures that exported files, such as PDFs, inherit the sensitivity label from the dataset. This maintains protection and compliance. The other options do not achieve automatic label inheritance for exports.

Answer

Configure the dataset to use row-level security (RLS) so that only authorized users can export the report.

Answer

Instruct the author to manually apply the same sensitivity label to the PDF file after exporting.

Answer

Publish the report to a Power BI app and require users to access it through the app.

Question 14

You are a Power BI administrator. Your organization has a Power BI Premium capacity. You need to configure a new workspace to use a specific capacity and ensure that only users with the 'Contributor' role can publish content to the workspace, while users with the 'Viewer' role can only view reports. Which two actions should you perform? (Choose two.)

Accepted Answer

Assign the workspace to the Premium capacity in the workspace settings.. To configure the workspace to use a specific Premium capacity, assign the workspace to that capacity in the workspace settings. To control publishing and viewing permissions, add users to the workspace with the Contributor or Viewer roles as appropriate. These two actions meet the requirements.

Answer

Enable the 'Allow contributors to update the app' setting in the workspace settings.

Answer

Configure row-level security (RLS) on the dataset to restrict data access based on user roles.

Answer

Create a sensitivity label and apply it to the workspace.

Question 15

You are a data analyst for a manufacturing company. You have a Power BI semantic model with a table named Production that includes a column ProductionDate of data type Date/Time. You need to create a calculated column that returns the year from ProductionDate. Which DAX function should you use?

Accepted Answer

YEAR(Production[ProductionDate]). The YEAR function is the correct DAX function to extract the year from a date column. It returns an integer and is efficient. The other options either return text, convert text to date, or are not valid DAX functions. Using YEAR is the standard approach for creating a year calculated column.

Answer

FORMAT(Production[ProductionDate], "YYYY")

Answer

DATEVALUE(Production[ProductionDate])

Answer

EXTRACT(YEAR FROM Production[ProductionDate])