PL-300 · topic practice

Manage and secure Power BI practice questions

Practise Microsoft Power BI Data Analyst PL-300 Manage and secure Power BI practice questions — original exam-style scenarios with answer choices, explanations, and analysis of common mistakes.

Courseiva uses original exam-style practice questions designed for learning and revision. The goal is to understand the concepts, recognise exam patterns, and improve through explanations — not memorise copied exam dumps.

Reviewed byJohnson Ajibi· MSc IT Security
20 questionsDomain: Manage and secure Power BI

What the exam tests

What to know about Manage and secure Power BI

Manage and secure Power BI questions test whether you can apply the concept in context, not just recognise a definition.

How the topic appears in realistic exam-style scenarios.

Which detail in the question changes the correct answer.

How to eliminate plausible but wrong options.

How to connect the question back to the wider exam objective.

Watch out for

Common Manage and secure Power BI exam traps

  • Answering from memory before reading the full scenario.
  • Missing a constraint such as cost, availability, security, scope or command context.
  • Choosing a broad answer when the question asks for the most specific fix.
  • Ignoring why the wrong options are tempting.

Practice set

Manage and secure Power BI questions

20 questions · select your answer, then reveal the explanation

You are a Power BI administrator. A user reports that a shared dashboard shows 'Sensitive data detected' for certain visualizations, but the dashboard is configured with row-level security (RLS). What is the most likely cause of this issue?

A Power BI administrator needs to enforce that all datasets published to the service use certified data sources only. Which two settings should be configured? (Choose two.)

You are a Power BI administrator. A user reports that their scheduled data refresh fails with error 'The data source credentials are no longer valid.' The dataset uses a SQL Server database with Windows authentication. What should you do first to resolve the issue?

You are a Power BI administrator. Your organization uses Microsoft Purview to manage sensitivity labels. You need to ensure that when a report is exported to PDF, the sensitivity label is automatically applied to the PDF file. What should you configure?

A Power BI administrator wants to allow users to create dashboards and reports, but prevent them from sharing content outside the organization. Which two settings should be configured in the Power BI admin portal? (Choose two.)

You are a Power BI administrator. A Power BI dataset owner reports that the dataset is not refreshing automatically, but manual refreshes work fine. The dataset uses a cloud data source (Azure SQL Database) with OAuth2 credentials. What is the most likely cause?

Refer to the exhibit. You are a Power BI administrator reviewing a workspace capacity configuration in the Power BI admin portal. Based on the exhibit, which of the following is true?

Exhibit

{
  "properties": {
    "encryption": "ServiceManaged",
    "dataClassification": "Confidential",
    "defaultDatasetStorageFormat": "ABFSSmall",
    "allowedDataSources": [
      "SQLServer",
      "AzureSQL",
      "OData"
    ]
  }
}

You are a Power BI administrator. A user in the Sales department needs to create reports using a shared dataset, but should not be able to modify the dataset or share it with others. What is the minimum permission level you should assign to the user on the dataset?

A Power BI administrator needs to audit which users have exported data from a specific report in the last 30 days. What is the most efficient way to retrieve this information?

Refer to the exhibit. You are reviewing a Power BI activity log entry. What action should you take to ensure compliance if the user who created the report should not have access to 'Confidential' data?

Exhibit

{
  "caller": "user@contoso.com",
  "operation": "CreateReport",
  "itemName": "SalesReport",
  "workspaceId": "12345678-1234-1234-1234-123456789012",
  "dataset": "SalesDataset",
  "sensitivityLabel": "Confidential"
}

You are a Power BI administrator. Your organization uses Microsoft Entra ID for identity management. You need to ensure that only users from specific security groups can access the Power BI service. What should you configure?

A Power BI administrator needs to prevent users from creating new workspaces, but allow existing workspaces to continue functioning. Which two settings should be configured? (Choose two.)

You are a Power BI administrator. A user reports that they cannot see a shared dashboard in their Power BI account. You verify that the dashboard has been shared with the user. What is the most likely cause?

You are a Power BI administrator. Your organization wants to use Microsoft Defender XDR to monitor Power BI activity for suspicious behavior. Which two components are essential for this integration? (Choose two.)

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?

Question 16mediummultiple choice
Read the full NAT/PAT explanation →

A company deploys Power BI for internal reporting. The security team requires that all report data be encrypted at rest and in transit, and that access be granted only to users with verified identities. Which combination of features should the Power BI administrator use?

A Power BI administrator needs to ensure that reports containing sensitive financial data are only accessible to users who have completed mandatory training and are using compliant devices. The organization uses Microsoft Entra ID and Microsoft Intune. Which feature should the administrator configure?

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?

Refer to the exhibit. A Power BI administrator is reviewing a dataset configuration exported from a workspace. The dataset connects to an on-premises SQL Server using Windows authentication. The administrator wants to configure a gateway to support scheduled refresh without storing credentials. Which gateway type and configuration should be used?

Exhibit

{
  "dataSources": [
    {
      "name": "SalesDB",
      "connectionString": "Data Source=sqlserver.contoso.com;Initial Catalog=Sales;Integrated Security=SSPI;"
    }
  ],
  "datasets": [
    {
      "name": "SalesDataset",
      "tables": [
        {
          "name": "Orders",
          "columns": [
            {"name": "OrderID", "dataType": "int"},
            {"name": "CustomerID", "dataType": "int"},
            {"name": "Amount", "dataType": "decimal"}
          ]
        }
      ]
    }
  ]
}

A Power BI administrator deploys a dashboard that uses a real-time dataset from Azure Stream Analytics. The dashboard must refresh every minute. The administrator notices that the dashboard sometimes shows stale data. What is the most likely cause and solution?

Free account

Track your progress over time

Create a free account to save your results and see which topics improve across sessions.

Focused Manage and secure Power BI sessions

Start a Manage and secure Power BI only practice session

Every question in these sessions is drawn from the Manage and secure Power BI domain — nothing else.

Related practice questions

Related PL-300 topic practice pages

Move into related areas when this topic feels solid.

Frequently asked questions

What does the PL-300 exam test about Manage and secure Power BI?
Manage and secure Power BI questions test whether you can apply the concept in context, not just recognise a definition.
How should I use these practice questions?
Select your answer before revealing the explanation. Then read why each option is right or wrong — this active recall approach builds retention far faster than re-reading notes.
Can I practise just Manage and secure Power BI questions in a focused session?
Yes — the session launcher on this page draws every question from the Manage and secure Power BI domain. Use a 10-question session first to gauge your baseline, then move to 20 or 30 once the weak spots are clear.
Where can I practise other PL-300 topics?
Use the topic links above to move to related areas, or go back to the PL-300 question bank to see all topics.
Are these real exam questions or dumps?
These are original practice questions written to test the same concepts the PL-300 exam covers. They are not copied from any real exam or dump site.