Microsoft Power BI Data Analyst (PL-300) Certification
Exam New 2026 Version with All 70 Questions from Actual
Exam, with 100% Correct Answers and Rationale
Question 1 (Prepare the Data)Which Power Query step removes duplicate rows from a dataset?
A. Remove Duplicates
B. Group By
C. Remove Rows
D. Filter Rows Correct Answer: A
Rationale: The "Remove Duplicates" step in Power Query eliminates duplicate rows based on
selected columns.
Question 2 (Model the Data)What is the BEST storage mode for a large dataset that requires
real-time updates?
A. Import
B. DirectQuery
C. Dual
D. Live Connection Correct Answer: B
Rationale: DirectQuery enables real-time data access without caching, ideal for large datasets
needing frequent updates.
Question 3 (Visualize and Analyze)Which visual in Power BI is BEST for showing trends over
time?
A. Pie Chart
B. Bar Chart
C. Line Chart
D. Table Correct Answer: C
Rationale: Line charts are ideal for visualizing trends over continuous time periods.
Question 4 (Manage and Secure)How do you restrict access to specific rows in a Power BI
dataset?
A. Column-level security
B. Row-level security (RLS)
C. Workspace roles
D. Dataflow permissions Correct Answer: B
Rationale: Row-level security (RLS) restricts data access at the row level based on user roles.
Question 5 (Prepare the Data)In Power Query, which transformation combines data from
multiple tables with the same structure?
A. Merge Queries
B. Append Queries
C. Join Queries
D. Group By Correct Answer: B
Rationale: Append Queries combines rows from multiple tables with similar structures into a
, single table.
Question 6 (Model the Data)Which DAX function calculates the total sales for the current year?
A. TOTALYTD
B. SUMX
C. CALCULATE
D. SUM Correct Answer: A
Rationale: TOTALYTD calculates the year-to-date total for a measure, such as sales, based on a
date column.
Question 7 (Visualize and Analyze)Which feature enhances a visual’s interactivity in Power BI?
A. Drillthrough
B. Conditional Formatting
C. Bookmarks
D. Slicers Correct Answer: D
Rationale: Slicers allow users to filter data interactively on a report page.
Question 8 (Manage and Secure)What is the purpose of a Power BI workspace?
A. Store raw data
B. Collaborate and share reports
C. Transform data
D. Create data models Correct Answer: B
Rationale: Workspaces in Power BI Service enable collaboration, sharing, and management of
reports and dashboards.
Question 9 (Prepare the Data)How do you handle null values in Power Query?
A. Replace Values
B. Remove Rows
C. Fill Down
D. All of the above Correct Answer: D
Rationale: Null values can be handled by replacing them, removing rows, or filling with adjacent
values, depending on the context.
Question 10 (Model the Data)What is the benefit of using a star schema in Power BI?
A. Reduces data redundancy
B. Increases data storage
C. Simplifies DAX calculations
D. Eliminates relationships Correct Answer: A
Rationale: A star schema reduces data redundancy and optimizes query performance by
organizing data into fact and dimension tables.
Question 11 (Visualize and Analyze)Which Power BI feature allows users to navigate to a
detailed report page?
A. Slicer
B. Drillthrough
C. Bookmark
Exam New 2026 Version with All 70 Questions from Actual
Exam, with 100% Correct Answers and Rationale
Question 1 (Prepare the Data)Which Power Query step removes duplicate rows from a dataset?
A. Remove Duplicates
B. Group By
C. Remove Rows
D. Filter Rows Correct Answer: A
Rationale: The "Remove Duplicates" step in Power Query eliminates duplicate rows based on
selected columns.
Question 2 (Model the Data)What is the BEST storage mode for a large dataset that requires
real-time updates?
A. Import
B. DirectQuery
C. Dual
D. Live Connection Correct Answer: B
Rationale: DirectQuery enables real-time data access without caching, ideal for large datasets
needing frequent updates.
Question 3 (Visualize and Analyze)Which visual in Power BI is BEST for showing trends over
time?
A. Pie Chart
B. Bar Chart
C. Line Chart
D. Table Correct Answer: C
Rationale: Line charts are ideal for visualizing trends over continuous time periods.
Question 4 (Manage and Secure)How do you restrict access to specific rows in a Power BI
dataset?
A. Column-level security
B. Row-level security (RLS)
C. Workspace roles
D. Dataflow permissions Correct Answer: B
Rationale: Row-level security (RLS) restricts data access at the row level based on user roles.
Question 5 (Prepare the Data)In Power Query, which transformation combines data from
multiple tables with the same structure?
A. Merge Queries
B. Append Queries
C. Join Queries
D. Group By Correct Answer: B
Rationale: Append Queries combines rows from multiple tables with similar structures into a
, single table.
Question 6 (Model the Data)Which DAX function calculates the total sales for the current year?
A. TOTALYTD
B. SUMX
C. CALCULATE
D. SUM Correct Answer: A
Rationale: TOTALYTD calculates the year-to-date total for a measure, such as sales, based on a
date column.
Question 7 (Visualize and Analyze)Which feature enhances a visual’s interactivity in Power BI?
A. Drillthrough
B. Conditional Formatting
C. Bookmarks
D. Slicers Correct Answer: D
Rationale: Slicers allow users to filter data interactively on a report page.
Question 8 (Manage and Secure)What is the purpose of a Power BI workspace?
A. Store raw data
B. Collaborate and share reports
C. Transform data
D. Create data models Correct Answer: B
Rationale: Workspaces in Power BI Service enable collaboration, sharing, and management of
reports and dashboards.
Question 9 (Prepare the Data)How do you handle null values in Power Query?
A. Replace Values
B. Remove Rows
C. Fill Down
D. All of the above Correct Answer: D
Rationale: Null values can be handled by replacing them, removing rows, or filling with adjacent
values, depending on the context.
Question 10 (Model the Data)What is the benefit of using a star schema in Power BI?
A. Reduces data redundancy
B. Increases data storage
C. Simplifies DAX calculations
D. Eliminates relationships Correct Answer: A
Rationale: A star schema reduces data redundancy and optimizes query performance by
organizing data into fact and dimension tables.
Question 11 (Visualize and Analyze)Which Power BI feature allows users to navigate to a
detailed report page?
A. Slicer
B. Drillthrough
C. Bookmark
