Introduction of Microsoft PL-300 Exam!

Microsoft PL-300 is an exam for the Microsoft Certified Power Platform Developer certification. It tests a candidate's skills in developing custom applications and solutions using the Power Platform, including Microsoft Power Apps, Power Automate, Power BI, and Common Data Service (CDS).

What is the Duration of Microsoft PL-300 Exam?

The Microsoft PL-300 exam is a two-hour exam.

What are the Number of Questions Asked in Microsoft PL-300 Exam?

There are approximately 40-60 questions on the Microsoft PL-300 exam.

What is the Passing Score for Microsoft PL-300 Exam?

The passing score required for the Microsoft PL-300 exam is 700 on a scale of 1000.

What is the Question Format of Microsoft PL-300 Exam?

The Microsoft PL-300 exam has a multiple-choice format. It consists of 40-60 questions that must be completed within a time limit of 150 minutes.

How Can You Take Microsoft PL-300 Exam?

Microsoft PL-300 exam can be taken online or at a testing center. To take the exam online, you must register for an account with Microsoft and purchase the exam. You will then receive an email with instructions on how to access the exam. To take the exam at a testing center, you must find a testing center near you that offers the exam and register for the exam. You will then receive an email with instructions on how to access the exam.

What Language Microsoft PL-300 Exam is Offered?

The Microsoft PL-300 exam is offered in English.

What is the Cost of Microsoft PL-300 Exam?

The cost of the Microsoft PL-300 exam is $165 USD.

What is the Target Audience of Microsoft PL-300 Exam?

The Microsoft PL-300 exam is intended for IT professionals who want to demonstrate their expertise in designing, implementing, and maintaining Microsoft Power Platform solutions. It is suitable for those who have experience in designing, developing, and deploying Power Platform solutions, including Power Apps, Power Automate, Power BI, and Common Data Service.

What is the Average Salary of Microsoft PL-300 Certified in the Market?

The average salary of Microsoft Power BI Data Analyst certified professionals varies widely by role, region, and experience, because it depends on the job the certification is combined with. Check current listings in your market for an up-to-date figure.

Who are the Testing Providers of Microsoft PL-300 Exam?

The testing provider for the Microsoft PL-300 exam is Pearson VUE, both at test centers and through its online proctored service.

What is the Recommended Experience for Microsoft PL-300 Exam?

The recommended experience for the Microsoft PL-300 exam is at least three years of experience with designing, implementing, and managing solutions with Microsoft 365 services, including Microsoft 365 tenant management, Microsoft 365 security and compliance, identity management, and Microsoft 365 workloads (SharePoint, Exchange, Teams, Skype for Business, and/or other Microsoft 365 services). Additionally, experience with Windows Server, Active Directory, Azure, and PowerShell scripting is recommended.

What is the Expected Retirement Date of Microsoft PL-300 Exam?

The Microsoft PL-300 exam is the current version of the Microsoft Power BI Data Analyst exam, and Microsoft has not announced a retirement date for it. When Microsoft introduces a newer version, the retirement date for the older version is published on the Microsoft certification site.

What is the Difficulty Level of Microsoft PL-300 Exam?

The Microsoft PL-300 exam is considered to be of a moderate difficulty level.

What is the Roadmap / Track of Microsoft PL-300 Exam?

The certification roadmap for the Microsoft PL-300 Exam is as follows: 1. Complete the Microsoft 365 Fundamentals (MS-900) Exam. 2. Complete the Microsoft 365 Identity and Services (MS-100) Exam. 3. Complete the Microsoft 365 Mobility and Security (MS-101) Exam. 4. Complete the Microsoft 365 Messaging (MS-200) Exam. 5. Complete the Microsoft 365 Teamwork (MS-300) Exam. 6. Complete the Microsoft 365 Security Administration (MS-500) Exam. 7. Complete the Microsoft 365 Compliance (MS-501) Exam. 8. Complete the Microsoft 365 DevOps (MS-600) Exam. 9. Complete the Microsoft 365 Deployment and Management (MS-700) Exam. 10. Complete the Microsoft 365 Enterprise Administration (MS-900) Exam. 11. Complete the Microsoft 365 Messaging

What are the Topics Microsoft PL-300 Exam Covers?

Microsoft PL-300 exam covers the following topics: 1. Designing and Implementing a Microsoft Azure Infrastructure: This section covers the skills and knowledge necessary to design and implement a secure, reliable, and resilient Azure infrastructure. It includes topics such as designing Azure virtual networks, configuring virtual networks, designing and configuring Azure Storage, and designing and implementing Azure App Services. 2. Securing Azure Resources: This section covers the skills and knowledge necessary to secure Azure resources. It includes topics such as implementing authentication, authorization, and secure access, configuring network security, and managing identity and access in Azure. 3. Monitoring and Optimizing Azure Solutions: This section covers the skills and knowledge necessary to monitor and optimize an Azure solution. It includes topics such as configuring Azure Monitor, analyzing and troubleshooting solutions, and optimizing performance. 4. Implementing Advanced Azure Solutions: This section covers the skills and knowledge necessary to implement advanced Azure solutions. It includes

What are the Sample Questions of Microsoft PL-300 Exam?

1. What is the purpose of the Azure Resource Manager? 2. How does Azure Key Vault help protect secrets? 3. What is the difference between Azure App Service and Azure Functions? 4. What is the process for deploying an application to Azure? 5. What is the role of Azure Monitor in the deployment of applications to Azure? 6. What are the considerations for designing a secure Azure environment? 7. How can Azure Security Center help protect your Azure resources? 8. How does Azure Active Directory help secure your applications? 9. What is the role of Azure Policy in managing Azure resources? 10. How can you use Azure Automation to manage your Azure resources?

← Back to exam page

Free PL-300 – Microsoft Power BI Data Analyst Practice Test Question

Q: What is the Competency Level required for Microsoft PL-300 Exam?

The Microsoft PL-300 exam is designed for individuals who have experience in building, deploying, and managing solutions with Microsoft Power Platform. The recommended level of competency for this exam is intermediate.

Free demo downloads

Loading demo links...

Showing 1–15 of 15 questions

Question 1 (Misc. Questions)

You are modifying a Power Bi model by using Power Bl Desktop.

You have a table named Sales that contains the following fields.

You have a table named Transaction Size that contains the following data.

Table Description automatically generated

You need to create a calculated column to classify each transaction as small, medium, or large based on the value in Sales Amount.How should you complete the code? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all.You may need to drag the split bar between panes or scroll to view content.NOTE: Each correct selection is worth one point.

Text, application Description automatically generated

Answer is in the explanation below.

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 2 (Misc. Questions)

You have a query named Customer that imports CSV files from a data lake. The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)

Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID.

You need to keep only the last modified row for each customer ID.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Answer is in the explanation below.

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 3 (Misc. Questions)

You are building a financial report by using Power BI.

You have a table named financials that contains a column named Date and a column named Sales.

You need to create a measure that calculates the relative change in sales as compared to the previous quarter.

How should you complete the measure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Diagram Description automatically generated

Answer is in the explanation below.

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 4 (Contoso Ltd, Case Study)

You need to grant access to the business unit analysts.

What should you configure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

$C:\Users\wk\Desktop\mudassar\Untitled.jpg$

Answer is in the explanation below.

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 7 (Misc. Questions)

You have a Microsoft Excel file in a Microsoft OneDrive folder.

The file must be imported to a Power Bi dataset

You need to ensure that the dataset can be refreshed in powefbi.com.

Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

○
Text/CSV
○
Folder
○
Excel Workbook
○
SharePoint folder
○
Web

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 8 (Misc. Questions)

You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server.

You need to ensure that all the visualization in the report can be consumed by users.

Which two types of visualizations should you exclude from the report? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

○
Funnel charts
○
Custom visuals
○
Bubble maps
○
Breadcrumbs
○
R visuals

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 9 (Misc. Questions)

In Power BI Desktop, you are creating a report that will contain three pages.

You need to create a custom tooltip page and prepare the page for use.

Which three actions should you perform? Each correct answer presents part of the solution.

Select all that apply, then click Submit answer.

○
Configure filters on the target visual.
○
For the target page, set Allow use as tooltip to On.
○
Add and configure visuals on the tooltip page.
○
For the tooltip page, set Allow use as tooltip to On.
○
For the tooltip page, configure filters.

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 10 (Contoso Ltd, Case Study)

Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

○
a line chart that shows balances by quarter filtered to account categories that are long-term liabilities.
○
a clustered column chart that shows balances by date (x-axis) and account category (legend) without
filters.
○
a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities.
○
a pie chart that shows balances by account category without filters.
○
a ribbon chart that shows balances by quarter and accounts in the legend.

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 11 (Litware, Inc. Case Study)

You need to create relationships to meet the reporting requirements of the customer service department.

What should you create?

Select an option, then click Submit answer.

○
an additional date table named ShipDate, a one-to-many relationship from
Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from
Sales[sales_ship_date_id] to ShipDate[date_id]
○
an additional date table named ShipDate, a many-to-many relationship from
Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from
Sales[sales_ship_date_id] to ShipDate[date_id]
○
a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]
○
a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many
relationship from Sales[sales_ship_date_id] to Date[date_id]
○
a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 12 (Misc. Questions)

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?

Select an option, then click Submit answer.

○
Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.
○
Publish the reports to a different workspace other than the one hosting the datasets.
○
Publish the reports in an app and grant the HR managers access permission.
○
Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 13 (Misc. Questions)

You have a Power Bl report that contains five pages.

Pages 1 to 4 are visible and page 5 is hidden.

You need to create a solution that will enable users to quickly navigate from the first page to all the other visible pages. The solution must minimize development and maintenance effort as pages are added to the report.

What should you do first?

Select an option, then click Submit answer.

○
Add a blank button to page 1.
○
Add a bookmark navigation button to page 1.
○
Create a bookmark for each page.
○
Add a page navigation button to page 1.

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 14 (Misc. Questions)

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.

The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.

The report is a single page that contains 15 custom visuals and 10 default visuals.

Users say that the report is slow to load the visuals when they access and interact with the report

You need to recommend a solution to improve the performance of the report.

What should you recommend?

Select an option, then click Submit answer.

○
Split the visuals onto multiple pages.
○
Implement row-level security (RLS).
○
Replace the default visuals with custom visuals.
○
Increase the number of times that the dataset is refreshed.

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 15 (Misc. Questions)

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.

You have a Microsoft SQL Server database that contains the following tables.

Table Description automatically generated

The following columns contain date information:

- Date[Month] in the mmyyyy format

- Date[Date_ID] in the ddmmyyyy format

- Date[Date_name] in the mm/dd/yyyy format

- Monthly_returns[Month_ID] in the mmyyyy format

The Order table contains more than one million rows.

The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.

You plan to use Power BI Desktop to create an analytics solution for the data.

You need to create a relationship between the Order table and the Store table on the Store_ID column.

What should you do before you create the relationship?

Select an option, then click Submit answer.

○
In the Order table query, use the Table.TrasformRows function.
○
In the Store table query, use the Table.TrasformRows function.
○
In the Store table query, use the Table.TrasformColumnTypes function.
○
In the Order table query, use the Table.TrasformColumnTypes function.

Ask AI for More Explanation

— your own AI account, opens inside the app

About the PL-300 Free Practice Test

Prepare for the Microsoft Power BI Data Analyst (PL-300) exam with this free practice test from Study4Pass, built around the real Microsoft syllabus. The 15 questions come free from the full 295-question Study4Pass practice set — a quick, honest check of where you stand. The free sample includes 5 single-answer, 4 multiple-answer, 2 drag-and-drop, 2 interactive and 2 hands-on lab questions — the same mix of formats you will meet in the full set. The set follows the real exam’s spread of topics: Prepare the data, Model the data, Visualize and analyze the data and Manage and secure Power BI. The real exam requires a score of 700 out of 1,000 to pass. Microsoft PL-300 is an exam for the Microsoft Certified Power Platform Developer certification.

The Microsoft PL-300 exam is intended for IT professionals who want to demonstrate their expertise in designing, implementing, and maintaining Microsoft Power Platform solutions. The prerequisite for the Microsoft PL-300 exam is to have a minimum of six months of experience in designing, deploying, and managing solutions with Microsoft 365 workloads, including Microsoft 365…

Certification: Microsoft Power BI Data Analyst (PL-300)
Vendor: Microsoft
Free on this page: 15 practice questions with answers and explanations
Full practice set: 295 questions

Work through the questions one at a time and read every explanation, even for the ones you get right — the reasoning behind an answer is what the real exam tests. If one area keeps costing you marks, you have found exactly what to revise before exam day.

Think of the result as a map, not a verdict. The questions you miss point straight at the topics that need work, and the explanations tell you why the correct option wins. Candidates who loop through that cycle — practise, review the reasoning, re-test — walk into the real exam having already seen their weak spots and fixed them.

Inside the full PL-300 practice set:

All 295 questions with answers and explanations
Timed Exam Simulation that mirrors the real exam pressure
Topic Training to drill one domain at a time
Ask AI for More Explanation on every question
Flag questions and review them before you finish

How to use this PL-300 free practice test

There is no clock and no account needed. Answer each question, check the result, and read the explanation before moving on. For anything that still feels unclear, Ask AI is built into this AI-Enabled practice test — it explains the concept behind the question so the next one like it gets easier. When the free sample feels comfortable, the full set of 295 questions adds timed Exam Simulation, topic-by-topic training, and flagged-question review — the closest thing to exam day you can get before the real thing.

What to study for each PL-300 domain

Prepare the data (25–30%) — This is the largest section of the PL-300 exam at 25–30% — give it the most study time, and do not book the exam until these questions feel comfortable.
Model the data (25–30%) — This is the largest section of the PL-300 exam at 25–30% — give it the most study time, and do not book the exam until these questions feel comfortable.
Visualize and analyze the data (25–30%) — This is the largest section of the PL-300 exam at 25–30% — give it the most study time, and do not book the exam until these questions feel comfortable.
Manage and secure Power BI (15–20%) — For Manage and secure Power BI, focus on understanding why each correct answer is right; the real exam rewards reasoning over recall.

PL-300 practice test — quick questions

Is this PL-300 practice test free?

Yes. Every question on this page — all 15 of them — is free to use, and you never need to create an account to try them.

How many questions are in the full PL-300 set?

The full Study4Pass set for PL-300 has 295 practice questions. This page gives you 15 of them free so you can judge the quality and difficulty first.

Does the free test show the answers?

Yes. Check any question to reveal the correct answer and its explanation, and use Ask AI whenever you want the underlying concept explained step by step.