PL-300
Power BI Data Analyst Associate
30 lessons · 214 questions · Recently updated
PL-300 practice test questions in the style of the real exam, a free 10-question mock test you can take without an account, and a full 50-question timed mock exam. Every answer comes with an explanation.
📖 Free study guideFull practice exam
50 questions · 100 minutes · timed, scored by domain · drawn from a bank of 184
Lessons by domain
Every lesson ends with a practice scenario on what you just read, with an explanation for every answer.
- FreeOpen
Domain 1: Prepare the data
8 lessons · 8 practice scenarios
- 🔒 Questions: ProOpen
Domain 2: Model the data
8 lessons · 8 practice scenarios
- 🔒 Questions: ProOpen
Domain 3: Visualize and analyze the data
8 lessons · 8 practice scenarios
- 🔒 Questions: ProOpen
Domain 4: Manage and secure Power BI
6 lessons · 6 practice scenarios
Free PL-300 sample questions
5 questions from the PL-300 practice test, with the answer and an explanation for each. They are original scenarios written from the public exam outline, not real exam questions.
Question 1
A report merges a SQL Server table of customers with an Excel workbook of customer notes on a company file share. Both hold internal company data that must never be sent to outside sources. Refresh fails because the sources' privacy levels can't be used together. Which privacy levels should you set?
- A.Public on SQL Server and Private on the workbook
- B.Organizational on both
- C.Public on both
- D.Private on both
Show answer and explanation
Correct answer: B
Organizational sources can be combined with each other, but their data isn't folded into queries sent to Public sources. That matches internal data that may be combined internally but must stay inside the organization.
Public would let the data be sent to any other source, which the requirement forbids. Private isolates a source from all others, so any combination that includes a Private source still fails.
From the lesson Connect to Data Sources, Credentials and Privacy Levels.
Question 2
A semantic model reports on a 2-billion-row Sales table in Azure SQL Database. Sales figures must reflect changes within a minute. The Product, Store and Date tables are small and change rarely. Which storage modes should you use?
- A.Import for all tables, with scheduled refresh
- B.DirectQuery for Sales, and Import for Product, Store and Date
- C.Direct Lake for all tables
- D.DirectQuery for Sales, and Dual for Product, Store and Date
Show answer and explanation
Correct answer: D
DirectQuery keeps Sales current without copying 2 billion rows. Dual on the dimensions lets them answer slicer queries from memory while still joining to Sales at the source, so relationships stay regular and queries stay efficient.
Import can't show changes within a minute. Import dimensions next to a DirectQuery fact create limited (weak) relationships and extra queries. Direct Lake only reads Delta tables in OneLake, not an Azure SQL database.
From the lesson Choose Between Import, DirectQuery and Direct Lake.
Question 3
A report connects to a development SQL Server while it's built and must connect to the production server after it's published. You must be able to switch servers without editing and republishing the .pbix file. What should you do?
- A.Change the data source credentials in the service
- B.Create a Power Query parameter for the server name, use it in the Source step, and change its value in the semantic model settings in the service
- C.Edit the server name in Power BI Desktop and republish for each environment
- D.Create a what-if parameter for the server name
Show answer and explanation
Correct answer: B
A Power Query parameter used in the Source step makes the server name a setting. After publishing, you change the parameter value in the semantic model's settings (or with deployment pipeline rules), with no edit to the .pbix.
Republishing is exactly what the requirement rules out. What-if parameters create a DAX table and slicer for numeric scenarios, not connection settings. Credentials control how Power BI signs in, not which server it connects to.
From the lesson Create and Modify Parameters.
Question 4
In Power Query, column quality shows 0% errors for the OrderDate column, yet refresh fails with a type conversion error in that column. The table has 2 million rows. What should you do first to find the bad values?
- A.Turn on Column distribution
- B.Remove errors from OrderDate
- C.Change OrderDate to the Text type
- D.Switch profiling to Column profiling based on entire data set
Show answer and explanation
Correct answer: D
By default the profiling tools look only at the top 1,000 rows, so errors further down are invisible. Profiling the entire data set shows the real error count and lets you find the offending values.
Column distribution still uses the same 1,000-row sample. Removing errors deletes rows without knowing what they are, and changing the type to Text hides the problem instead of locating it.
From the lesson Profile and Clean the Data.
Question 5
A ProductCode column contains values such as 00451 and 01290. After loading, the report shows 451 and 1290, and lookups against another system fail. What should you do?
- A.Apply a custom format string of 00000 in the model
- B.Set the ProductCode column's data type to Text in Power Query
- C.Set the data type to Whole number
- D.Set the data type to Fixed decimal number
Show answer and explanation
Correct answer: B
Codes are identifiers, not numbers. As Text, the leading zeros are kept exactly as in the source, so the values match the other system.
Whole number and Fixed decimal number both store a number, which drops leading zeros. A format string only changes the display; the stored value is still 451, so lookups and relationships still fail.
From the lesson Data Types, Column Transformations and Grouping.