Courseiva

PL-300 · topic practice

Deploy and maintain assets practice questions

Practise Microsoft Power BI Data Analyst PL-300 Deploy and maintain assets 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: Deploy and maintain assets
Practice 10 questionsBrowse domain →

What the exam tests

What to know about Deploy and maintain assets

Deploy and maintain assets 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 Deploy and maintain assets 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

Deploy and maintain assets questions

20 questions · select your answer, then reveal the explanation

Question 1mediummultiple choice
Read the full Deploy and maintain assets explanation →

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?

Question 2easymultiple choice
Read the full Deploy and maintain assets explanation →

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?

Question 3hardmultiple choice
Read the full Deploy and maintain assets explanation →

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?

Question 4mediummultiple choice
Read the full Deploy and maintain assets explanation →

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?

Question 5hardmultiple choice
Read the full Deploy and maintain assets explanation →

You have a Power BI dataset that is refreshed every hour from an on-premises data source using an enterprise gateway. The refresh consistently fails at 2:00 AM. What is the most likely cause?

Question 6mediummulti select
Read the full Deploy and maintain assets explanation →

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?

Question 7hardmulti select
Read the full Deploy and maintain assets explanation →

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

Question 8easymultiple choice
Read the full Deploy and maintain assets explanation →

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

Exhibit

Refer to the exhibit.

Dataset Refresh History:
Refresh #1: Start: 2024-01-15 01:00:00, End: 2024-01-15 01:05:00, Status: Completed
Refresh #2: Start: 2024-01-15 02:00:00, End: 2024-01-15 02:30:00, Status: Failed
Refresh #3: Start: 2024-01-15 03:00:00, End: 2024-01-15 03:03:00, Status: Completed
Question 9mediummultiple choice
Read the full Deploy and maintain assets explanation →

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?

Exhibit

Refer to the exhibit.

Power BI XMLA endpoint configuration:
{
  "allowedUsers": [
    "user1@contoso.com",
    "user2@contoso.com"
  ],
  "allowAzureAnalysisServicesConnections": true,
  "blockExternalConnections": false
}
Question 10easymultiple choice
Read the full Deploy and maintain assets explanation →

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?

Question 11mediummultiple choice
Read the full Deploy and maintain assets explanation →

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?

Question 12hardmultiple choice
Read the full Deploy and maintain assets explanation →

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?

Question 13easymultiple choice
Read the full Deploy and maintain assets explanation →

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?

Question 14mediummultiple choice
Read the full Deploy and maintain assets explanation →

You publish a Power BI report to a workspace that uses an organizational app. After updating the report, you want users to see the changes immediately without having to reinstall the app. What should you do?

Question 15mediummulti select
Read the full Deploy and maintain assets explanation →

Which TWO actions are required to set up a Power BI deployment pipeline with separate data sources for Development and Production?

Question 16hardmulti select
Read the full Deploy and maintain assets explanation →

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

Question 17hardmultiple choice
Read the full Deploy and maintain assets explanation →

You are reviewing the deployment configuration for a Power BI dataset. The exhibit shows a JSON snippet of the dataset settings. You need to ensure that data is refreshed twice a day at 6:00 AM and 6:00 PM UTC. However, the refresh fails at both scheduled times. What is the most likely cause?

Exhibit

Refer to the exhibit.

{
  "version": "1.0",
  "datasetSettings": {
    "refreshSchedule": {
      "frequency": "Daily",
      "times": ["06:00", "18:00"],
      "enabled": true,
      "localTimeZone": "UTC"
    },
    "directQuery": {
      "enableDirectQuery": false
    }
  },
  "dataSources": [
    {
      "name": "SalesDB",
      "connectionString": "Server=sqlsrv01;Database=Sales;Integrated Security=SSPI;",
      "credentialType": "Windows",
      "gatewayId": "gateway-cluster-01"
    }
  ]
}
Question 18mediummultiple choice
Read the full Deploy and maintain assets explanation →

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?

Question 19hardmultiple choice
Read the full NAT/PAT explanation →

You are a Power BI administrator for a large organization. A team has published a shared dataset to a Premium workspace. They use an XMLA endpoint to programmatically refresh the dataset daily. Recently, the refresh started failing with the error: 'The operation was canceled because the session was terminated by a concurrent operation.' The dataset is not partitioned. You need to ensure the refresh completes without errors. What should you do?

Question 20easymultiple choice
Read the full Deploy and maintain assets explanation →

You have developed a Power BI report that uses a live connection to an Azure Analysis Services (AAS) model. The AAS model is deployed in a different Azure region. Users report that the report loads slowly, sometimes taking over 30 seconds to render a single visual. You need to improve performance without changing the data model or the report structure. What should you do?

Continue with 20-question session →

Free account

Track your progress over time

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

Sign up freeLog in

Focused Deploy and maintain assets sessions

Start a Deploy and maintain assets only practice session

Every question in these sessions is drawn from the Deploy and maintain assets domain — nothing else.

10 questions20 questions30 questions50 questions
Browse all Deploy and maintain assets questions →Mixed PL-300 session

Related practice questions

Related PL-300 topic practice pages

Move into related areas when this topic feels solid.

Prepare the data practice questions

Practise PL-300 questions linked to Prepare the data.

Deploy and maintain assets practice questions

Practise PL-300 questions linked to Deploy and maintain assets.

Model the data practice questions

Practise PL-300 questions linked to Model the data.

Visualize and analyze the data practice questions

Practise PL-300 questions linked to Visualize and analyze the data.

Manage and secure Power BI practice questions

Practise PL-300 questions linked to Manage and secure Power BI.

PL-300 fundamentals practice questions

Practise PL-300 questions linked to PL-300 fundamentals.

PL-300 scenario practice questions

Practise PL-300 questions linked to PL-300 scenario.

PL-300 troubleshooting practice questions

Practise PL-300 questions linked to PL-300 troubleshooting.

Frequently asked questions

What does the PL-300 exam test about Deploy and maintain assets?
Deploy and maintain assets 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 Deploy and maintain assets questions in a focused session?
Yes — the session launcher on this page draws every question from the Deploy and maintain assets 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.