PL-300 Practice Test 39 — 15 Questions

Question 1

You are managing a Power BI deployment that uses Premium capacity. Users report that reports are loading slowly during peak hours. You need to identify whether the capacity is being overused. Which metric should you monitor?

Accepted Answer

CPU high time percentage.. Option C is correct because CPU over-utilization is a key indicator of capacity stress in Premium. The 'CPU high' metric directly reflects processing load. Option A is wrong because query execution time is a result, not a direct capacity metric. Option B is wrong because memory usage is important but CPU is more directly tied to responsiveness. Option D is wrong because dataset size is a design factor, not a real-time capacity metric.

Answer

Memory usage percentage.

Answer

Total dataset size in the workspace.

Answer

Average query execution time.

Question 2

Refer to the exhibit. You are reviewing a DAX expression used in a Power BI measure. You need to ensure that only users in the 'West' region see data for that region. Which approach should you use?

Accepted Answer

Implement row-level security (RLS) in the dataset with a role filter.. Option C is correct because the DAX expression is a measure that calculates the sum for the 'West' region, but it does not restrict data for other users. To enforce security, you need to implement row-level security (RLS) by adding a filter in the dataset roles. Option A is wrong because you cannot restrict the measure to specific users directly. Option B is wrong because the measure itself calculates for West only, but RLS is needed for security. Option D is wrong because the measure is already specific to West.

Answer

Use the CALCULATE function with a filter on the report page.

Answer

Modify the measure to include a conditional statement that checks the user's email.

Answer

Create a calculated column with the same logic.

Question 3

Which TWO actions should a Power BI admin take to ensure compliance with data residency requirements? (Choose two.)

Accepted Answer

Configure the default storage location in the Power BI admin portal.. Options A and D are correct because data residency can be controlled by choosing the region where the tenant is created and by using Multi-Geo capabilities for Premium capacities. Option B is wrong because data is stored in the region of the capacity. Option C is wrong because the admin portal does not allow users to choose residency. Option E is wrong because Azure Data Lake is not a storage for Power BI data.

Answer

Enable 'Data residency' settings in the admin portal.

Answer

Use Power BI Report Server for on-premises data.

Answer

Store datasets in Azure Data Lake Storage.

Question 4

You are a Power BI administrator. You need to prevent users from exporting underlying data from reports. Which tenant setting should you disable?

Accepted Answer

'Export data'. Option A is correct because 'Export data' controls the ability to export underlying data. Option B is wrong because 'Export reports as PowerPoint' is for exporting the report itself. Option C is wrong because 'Export reports as PDF' is for static exports. Option D is wrong because 'Export reports as MHTML' is also for report export.

Answer

'Export reports as PowerPoint presentations'

Answer

'Export reports as PDF files'

Answer

'Export reports as MHTML files'

Question 5

An administrator wants to monitor all Power BI activities, including viewing reports, exporting data, and sharing workspaces. Which tool should they use?

Accepted Answer

Power BI activity log in the admin portal. Option A is correct because the Power BI activity log captures user activities such as viewing, exporting, and sharing. Option B is wrong because the usage metrics report shows aggregate usage, not detailed activities. Option C is wrong because Microsoft 365 audit log is broader but less specific to Power BI; the activity log is the dedicated tool. Option D is wrong because the admin portal's capacity metrics focus on performance.

Answer

Power BI usage metrics report

Answer

Power BI capacity metrics app

Answer

Microsoft 365 audit log

Question 6

You have a Power BI capacity that is frequently hitting its memory limits, causing refreshes to fail. You need to reduce memory usage without increasing capacity size. What should you do?

Accepted Answer

Reduce the number of parallel data refresh operations.. Option A is correct because reducing the number of parallel data refreshes reduces memory pressure. Option B is incorrect because increasing scheduled refresh frequency increases memory usage. Option C is incorrect because removing RLS does not reduce memory usage significantly. Option D is incorrect because increasing the eviction time keeps more data in memory, worsening the issue.

Answer

Increase the eviction time for unused data.

Answer

Remove row-level security (RLS) from the dataset.

Answer

Increase the frequency of scheduled refreshes.

Question 7

You manage a Power BI environment where users frequently create personal workspaces. The finance team requires that all financial reports be placed in a managed workspace to enforce data protection labels from Microsoft Purview. What should you implement to prevent users from saving financial reports to their personal workspaces?

Accepted Answer

Disable the 'Create workspaces (My Workspace)' tenant setting in the admin portal.. Option C is correct because the Power BI admin portal allows you to block the creation of personal workspaces, forcing users to use managed workspaces. Option A is wrong because sensitivity labels are applied to content but do not prevent saving to personal workspaces. Option B is wrong because tenant settings for sharing do not restrict workspace creation. Option D is wrong because the external data sharing setting is unrelated.

Answer

Require sensitivity labels on all financial datasets.

Answer

Disable the 'Allow sharing with external users' tenant setting.

Answer

Enable the 'Block external data sharing' setting in Microsoft Purview.

Question 8

You need to restrict access to a Power BI report that contains sensitive financial data. The report is published to a workspace. Which THREE actions can you take to control access? (Choose three.)

Accepted Answer

Implement row-level security (RLS) to filter data based on user identity.. Options A, C, and D are correct. Assigning workspace roles controls who can view content in the workspace. Sharing the report with specific users allows granular access. Row-level security (RLS) can filter data per user. Option B is wrong because sensitivity labels do not control access; they classify data. Option E is wrong because the 'Export to Excel' setting controls export, not access.

Answer

Disable the 'Export to Excel' setting for the report.

Answer

Apply a sensitivity label that restricts access to the report.

Question 9

Your organization is implementing a data sensitivity labeling strategy for Power BI. You have created labels in Microsoft Purview Compliance Portal. After publishing a report, you notice that some labels are not available for selection in Power BI. What is the most likely cause?

Accepted Answer

The labels are not included in a label policy that applies to Power BI.. Option D is correct because sensitivity labels must be published in a label policy that includes Power BI as a target. Option A is wrong because label creation does not require Premium. Option B is wrong because labels are configured centrally, not per workspace. Option C is wrong because user licenses affect consumption, not label availability.

Answer

The labels were created in the wrong workspace.

Answer

The Power BI tenant does not have Premium capacity.

Answer

Users do not have Power BI Pro licenses.

Question 10

A Power BI admin receives a support ticket that a user cannot see any data in a report that uses row-level security (RLS). The report is based on a dataset with a single table 'Sales' and RLS roles defined. The user is assigned to the role 'SalesManager' which filters Sales[Region] = 'West'. The dataset uses Import mode. The user can see the report but all visuals show blank. What is the most likely cause?

Accepted Answer

The RLS filter removes all rows for the user's role.. Option D is correct because RLS in Import mode filters at the dataset level; if the user's role filters out all data (e.g., no rows match 'West'), visuals will appear blank. Option A is wrong because RLS does not affect the report page layout. Option B is wrong because RLS is applied regardless of dashboard tiles. Option C is wrong because RLS is applied after data refresh, so the data load includes all rows but RLS filters query results.

Answer

The user does not have permission to view the report page.

Answer

The user is viewing a dashboard tile instead of the report.

Answer

The dataset was refreshed using an RLS bypass account.

Question 11

Which TWO methods can a Power BI admin use to enforce the use of sensitivity labels on reports? (Choose two.)

Accepted Answer

Apply labels automatically using Microsoft Purview Information Protection.. Options A and D are correct because the admin can enable mandatory labeling in the admin portal and use Microsoft Purview Information Protection to apply labels. Option B is wrong because labels are not applied in Power BI Desktop. Option C is wrong because RLS does not enforce labels. Option E is wrong because there is no such policy in Microsoft Intune.

Answer

Deploy a Microsoft Intune policy to block unlabeled reports.

Answer

Configure default labels in Power BI Desktop.

Answer

Use row-level security to hide unlabeled reports.

Question 12

You are managing a Power BI environment that uses Microsoft Purview for data governance. You need to ensure that all new datasets automatically inherit sensitivity labels from their source data. What should you configure?

Accepted Answer

In Microsoft Purview, set up 'Automatic labeling' policies that propagate labels from source to Power BI datasets.. Option D is correct because you need to set Purview to automatically apply labels based on source data labels. Option A is wrong because it only applies manual labels. Option B is wrong because it doesn't automatically inherit. Option C is wrong because it's for classification, not automatic inheritance.

Answer

Enable 'Sensitivity labels' in Power BI tenant settings and require labels on datasets.

Answer

Use Microsoft Purview Data Map to scan source data and manually apply labels.

Answer

Configure a Power Automate flow to apply labels based on dataset metadata.

Question 13

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.. Option D is correct because Power BI supports automatic labeling via default labels at the workspace level, which can be set by administrators or workspace owners. Option A is wrong because manual labeling is not automatic. Option B is wrong because Microsoft Purview auto-labeling policies apply to the service as a whole, not per workspace. Option C is wrong because the tenant default label applies to all workspaces, not a specific one.

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 14

Which TWO actions are required to enable Bring Your Own Key (BYOK) encryption for Power BI datasets? (Select exactly two.)

Accepted Answer

Upload the customer-managed key to Azure Key Vault. Options B and D are correct. BYOK requires uploading the encryption key to Azure Key Vault and configuring the Power BI admin settings to use the key. Option A is wrong because the key is stored in Azure Key Vault, not Power BI. Option C is wrong because BYOK does not require a Premium capacity; it works with Premium Per User or Premium capacity. Option E is wrong because the key is not stored in Microsoft Purview.

Answer

Assign the workspace to a Power BI Premium capacity

Answer

Store the encryption key in the Power BI service admin settings

Answer

Register the encryption key in Microsoft Purview compliance portal

Question 15

You manage a Power BI environment where users create reports using data from Azure SQL Database. You need to enforce that all data sources use Single Sign-On (SSO) with Microsoft Entra ID. What should you do?

Accepted Answer

In the Power BI admin portal, block authentication methods other than OAuth2.. Option D is correct because you can block other authentication methods via tenant settings in the Power BI admin portal. Option A is incorrect because SSO is configured per data source, not globally in a security group. Option B is incorrect because the 'Allow data sources to use SSO' setting enables SSO but does not block other methods. Option C is incorrect because you cannot block authentication methods in the dataset itself.

Answer

Configure the dataset to use SSO in the Power BI service.

Answer

Enable the 'Allow data sources to use SSO' tenant setting.

Answer

Create a security group for SSO-enabled data sources and assign it to the workspace.