Page: 1
/ 14
Total 470 questions
Microsoft Power BI Data Analyst PL-300 Exam Questions
Question 1
Your company has employees in 10 states.
The company recently decided to associate each state to one of the following three regions: East, West, and North.
You have a data model that contains employee information by state. The model does NOT include region
information.
You have a report that shows the employees by state.
You need to view the employees by region as quickly as possible.
What should you do?
Answer : B
The answer resolves to B (Create a new group on the state column and set the Group type to List). A lookup-to-fact design normally uses one-to-many cardinality and single-direction filtering from the unique key to the repeating key. That creates predictable propagation and avoids an unnecessary ambiguous filter path. The deciding requirement in this question is to view the employees by region as quickly as possible. The opposite cardinality or unnecessary bidirectional filtering can duplicate results, block propagation, or create ambiguity rather than solve the stated model path. For exam alignment, this is assessed under 'Define a relationship's cardinality and cross-filter direction' in the current study guide.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand | PL-300 objective: 'Define a relationship's cardinality and cross-filter direction' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300
Question 2
You have two Power BI reports named ReportA and ReportB that each uses a distinct color palette.
You are creating a Power BI dashboard that will include two visuals from each report
You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Answer : B, D
The supported selection is B (Select the dark dashboard theme); D (When pinning visuals to the dashboard, select Use destination theme). A dashboard is a Power BI service canvas made from pinned tiles. Tile behavior, themes, mobile layout, and pinning are managed separately from the report page that supplied a visual. The deciding requirement in this question is to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports. Editing only the source report does not necessarily update an existing dashboard tile's type, placement, theme, or phone layout. For exam alignment, this is assessed under 'Create dashboards' in the current study guide.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/create-reports/service-dashboard-tiles | PL-300 objective: 'Create dashboards' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300
Question 3
You have an on-premises data gateway.
You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.
Solution: You decrease the dashboard cache update frequency.
Does this meet the goal?
Answer : B
The key constraint is to evaluate whether this proposal meets the goal: You decrease the dashboard cache update frequency. Select B (No). The proposed action - You decrease the dashboard cache update frequency - does not satisfy the stated goal. A full refresh repeatedly transfers historical rows that no longer change, defeating the requirement to reduce refresh volume and duration. Incremental refresh partitions a large table and refreshes only the recent period that can change. For imported models using an on-premises source, that reduces the volume of data transferred through the gateway. The current skills outline describes this competency as 'Configure a semantic model scheduled refresh'.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview | PL-300 objective: 'Configure a semantic model scheduled refresh' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300
Question 4
The tables have the following relationships.
You have 100 salespeople in 10,000 cities. Each salesperson sells in multiple cities.
You import one million rows into the Sales table.
You need to reduce the size of Model1. The solution must ensure that you can analyze the total number of sales by salesperson per city.
Solution: You remove the ProductID column from the Sales table.
Does this meet the goal?
Answer : A
Answer A (Yes). The proposal - You remove the ProductID column from the Sales table - meets the requirement as written. The scenario is asking for a way to evaluate whether this proposal meets the goal: You remove the ProductID column from the Sales table. The opposite cardinality or unnecessary bidirectional filtering can duplicate results, block propagation, or create ambiguity rather than solve the stated model path. Cardinality describes uniqueness on each side of a relationship; cross-filter direction controls how filters travel. Both settings must match the model grain or totals and security filtering can become unreliable. In Microsoft's current exam outline, the corresponding objective is 'Define a relationship's cardinality and cross-filter direction'.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand | PL-300 objective: 'Define a relationship's cardinality and cross-filter direction' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300
Question 5
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a data source that contains a column. The column contains case sensitive data.
You have a Power BI semantic model in DirectQuery mode.
You connect to the model and discover that it contains undefined values and errors.
You need to resolve the issue.
Solution: You implicitly convert the values into the required type.
Does this meet the goal?
Answer : B
What determines the answer is the need to evaluate whether this proposal meets the goal: You implicitly convert the values into the required type. The correct response is B (No): the proposed action - You implicitly convert the values into the required type - does not meet that requirement. Implicit type conversion does not correct inconsistent casing in a case-sensitive DirectQuery source. Normalize the values in the source or in a foldable Power Query step so matching keys use the same representation. A visual, measure, or model relationship cannot repair the incoming tabular shape; those features operate after the query result has already been loaded. The current PL-300 study guide places this under the objective 'Resolve inconsistencies, unexpected or null values, and data quality issues'.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-query/best-practices | PL-300 objective: 'Resolve inconsistencies, unexpected or null values, and data quality issues' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300
Question 6
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You write a DAX expression that uses the FILTER function.
Does this meet the goal?
Answer : B
Answer B (No). The proposal - You write a DAX expression that uses the FILTER function - does not deliver the required result. The required outcome is to evaluate whether this proposal meets the goal: You write a DAX expression that uses the FILTER function. An alternative that changes the source or creates a stored column either ignores filter context or increases model size without meeting a dynamic measure requirement. DAX calculations depend on evaluation context. Aggregators, iterators, and filter-modifying functions must be combined so the expression evaluates the intended rows while retaining or replacing filters only where required. In Microsoft's current exam outline, the corresponding objective is 'Create model calculations by using DAX'.
Microsoft Learn reference: https://learn.microsoft.com/en-us/dax/ | PL-300 objective: 'Create model calculations by using DAX' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300
Question 7
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an on-premises data gateway.
You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.
Solution: You configure incremental refresh.
Does this meet the goal?
Answer : A
Select A (Yes). The proposed action - You configure incremental refresh - satisfies the stated goal. The key constraint is to evaluate whether this proposal meets the goal: You configure incremental refresh. Incremental refresh partitions a large table and refreshes only the recent period that can change. For imported models using an on-premises source, that reduces the volume of data transferred through the gateway. This directly matches the current study-guide objective 'Configure a semantic model scheduled refresh'. A full refresh repeatedly transfers historical rows that no longer change, defeating the requirement to reduce refresh volume and duration. This keeps service access and operational behavior within the scope requested instead of granting or changing unrelated capabilities.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview | PL-300 objective: 'Configure a semantic model scheduled refresh' | Study guide: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/pl-300
All Official Question Types