Microsoft Power BI Data Analyst PL-300
Comprehensive Exam Questions and Answers
You need to identify the percentage of empty values in each column as quickly as
possible. What data preview option do you select? - ANSWER-Column Quality
You need to identify outliers in a text column. Which data preview option do you select?
- ANSWER-Top and bottom values in Value Distribution
What is the relationship between the fact table and the dimension tables? - ANSWER-
Many to One
What kind of data is in a fact table? - ANSWER-Observational data (sales orders,
shipping dates, employees)
What kind of data is in a dimension table? - ANSWER-Specific entities like product IDs
and calendar dates, details about business entities
You have a Power BI Desktop dataset based on a star schema data source.
You need to use Data Analysis Expression (DAX) to create a date table in the dataset
and populate the table with a range of dates based on the earliest and latest date within
the dataset.
Which function should you use?
CALENDAR
CALENDARAUTO
DATE
DATEDIFF - ANSWER-CALENDARAUTO
In Power BI Desktop, you plan to use M-language to define a common date table
spanning a period of 10 years.
You need identify the M language function that would allow you to specify that rows in
the table should represent consecutive days within the date range you designated. Your
solution must minimize administrative effort.
Which syntax should you use?
#date
#duration
List.Combine
List.Duration - ANSWER-#duration
What are 3 items that cannot be assigned a display folder? - ANSWER-Measure,
Column, Calculated Column
,To create a quick measure in Desktop, which 2 elements can you use? - ANSWER-
Calculations, Fields
What is a feature of implicit measure that explicit would not have? - ANSWER-End
Users can change the aggregation type of implicit measures from the values of a visual
What do you select to determine query timings for visuals? - ANSWER-Performance
Analyzer
Where can you modify storage mode of tables? - ANSWER-Model view
2 Main Benefits of DirectQuery over Import? - ANSWER-Minimized need for data
refresh, minimized local disk space usage
2 Benefits of Import over Direct Query? - ANSWER-Full support of q&a and quick
insights
Need to ensure a server name can be changed after the dataset has been published to
pbi service. What 2 actions can you perform? - ANSWER-Create a parameter, update
server source to use a parameter in data source settings
Need to identify data anomalies in Excel file. Column distribution must consider all rows
in Excel file. - ANSWER-Use Column Profile View in Power Query Editor
Need to ensure column statistics are based on the analysis of an entire dataset -
ANSWER-From the status bar, change profiling status to entire dataset
Query named FactSales from SQL. Need to update the query to prevent new columns
that may be added to the table in the future from getting imported during data refreshes.
You select existing columns in the query. What two applied steps can you use in Power
Query Editor to achieve this goal?
Choose Columns
Remove Columns
Remove Other Columns
Transpose - ANSWER-Choose Columns, Remove Other Columns
From Power Query Editor, you import a CSV. Data includes ZIP. It is auto applied as
whole number. You need to ensure that ZIP is text with 5 character values. - ANSWER-
In Power Query Editor, update the current changed type step and replace convert from
number to text.
You connect Power Query Editor to a database table.
You need to remove the Row ID column. Your solution must ensure that new columns
do NOT display in the table model during a scheduled refresh in the future.
,What transformation should you use?
Select Row ID, then use the Remove Other Columns Command
Use the Remove Column command on the Row ID column
Use the select columns command and choose the columns to keep
use the transpose command then filter the rows to remove row id - ANSWER-Use
select columns command and choose columns to keep
only select columns command lets you choose columns to keep, delete columns you
don't want and prevent new columns from showing up
You have a fact table that contains sales data. The fact table includes a SalesDate
column. Auto date/time is disabled in global and current file options. You load table. You
need to ensure that you are able to analyze data using dates. Your solution must
minimize the model size and admin effort. - ANSWER-Add a separate date dimension
table
You upload reports to Power BI service and pin visuals to a dashboard. You plan to
create alert rules for several visuals. Where can you see alerts? - ANSWER-Email,
Microsoft Teams
You need to add new visuals to a Power BI Dashboard. This visual does not exist on a
report in the workspace. What should you do first? - ANSWER-Select Ask a question
about your data (Q&A can create a new visual without adding it to a report)
You plan to certify a Power BI dataset.
You need to identify at which level within your organization the permissions to certify a
dataset are assigned.
Which level should you identify?
Select only one answer.
Dataset
Tenant
Workbook
Workspace - ANSWER-Tenant
You manage a workspace in a shared capacity. The workspace contains a dataset
named DS1. How many consecutive refresh failures will automatically disable the
refresh? - ANSWER-4
You need to set a dataset as discoverable. Which 2 configurations will allow the dataset
to be marked as such? - ANSWER-Certify dataset, promote dataset
You need to delegate the task to schedule data refreshes. The solution must have the
principle of least privilege. What role should you use? - ANSWER-Contributor
Premium Workspace. What is the maximum number of refreshes that can be
, scheduled? - ANSWER-48
You plan to create a report in Desktop. You need to create a visualization that displays
data in 2 or more dimensions and cross-highlights with other visuals on the same report.
What type of visual? - ANSWER-Matrix
You plan to create a report in Power BI Desktop.
You need to identify the type of visualization that displays data as a set of nested
rectangles.
Which visualization should you use?
Bar Chart
Column Chart
Slicer
Treemap - ANSWER-Treemap
Need to create a visual that displays sales by employees, trending over months. The
visual must clearly show how employees are performing against each other and have a
ranking. What visual? - ANSWER-Ribbon chart.
You implement the Q&A feature in a report, so users can get answers to their questions
on their own.
You need to improve your Q&A search capabilities for end-users.
Which two configurations can you add? Each correct answer presents a complete
solution.
Add a linguistic schema
Add synonyms to model fields
Configure the dataset as a composite model
Organize the dataset columns and measures into logical folders in the fields pane -
ANSWER-Linguistics schema and synonyms to model fields
You are using Power BI Desktop to edit a stacked column chart that displays gross
sales data with a date hierarchy that contains year, quarter, month, and day.
You need to prevent users from viewing the hierarchy based on the year.
What should you do?
In the Filters pane, add a filter based on the quarter, month, and day.
In the Filters pane, add a filter based on the year.
In the Format pane, modify the Maximum Range setting.
In the Visualization pane, remove the year field from the date hierarchy fields in the X-
axis. - ANSWER-In the Visualization pane, remove the year field from the date
hierarchy fields in the X-axis.
You have a visual that is being cross-highlighted. By default, what data will be displayed
in a report tool tip? - ANSWER-The filtered (cross highlighted) data
Comprehensive Exam Questions and Answers
You need to identify the percentage of empty values in each column as quickly as
possible. What data preview option do you select? - ANSWER-Column Quality
You need to identify outliers in a text column. Which data preview option do you select?
- ANSWER-Top and bottom values in Value Distribution
What is the relationship between the fact table and the dimension tables? - ANSWER-
Many to One
What kind of data is in a fact table? - ANSWER-Observational data (sales orders,
shipping dates, employees)
What kind of data is in a dimension table? - ANSWER-Specific entities like product IDs
and calendar dates, details about business entities
You have a Power BI Desktop dataset based on a star schema data source.
You need to use Data Analysis Expression (DAX) to create a date table in the dataset
and populate the table with a range of dates based on the earliest and latest date within
the dataset.
Which function should you use?
CALENDAR
CALENDARAUTO
DATE
DATEDIFF - ANSWER-CALENDARAUTO
In Power BI Desktop, you plan to use M-language to define a common date table
spanning a period of 10 years.
You need identify the M language function that would allow you to specify that rows in
the table should represent consecutive days within the date range you designated. Your
solution must minimize administrative effort.
Which syntax should you use?
#date
#duration
List.Combine
List.Duration - ANSWER-#duration
What are 3 items that cannot be assigned a display folder? - ANSWER-Measure,
Column, Calculated Column
,To create a quick measure in Desktop, which 2 elements can you use? - ANSWER-
Calculations, Fields
What is a feature of implicit measure that explicit would not have? - ANSWER-End
Users can change the aggregation type of implicit measures from the values of a visual
What do you select to determine query timings for visuals? - ANSWER-Performance
Analyzer
Where can you modify storage mode of tables? - ANSWER-Model view
2 Main Benefits of DirectQuery over Import? - ANSWER-Minimized need for data
refresh, minimized local disk space usage
2 Benefits of Import over Direct Query? - ANSWER-Full support of q&a and quick
insights
Need to ensure a server name can be changed after the dataset has been published to
pbi service. What 2 actions can you perform? - ANSWER-Create a parameter, update
server source to use a parameter in data source settings
Need to identify data anomalies in Excel file. Column distribution must consider all rows
in Excel file. - ANSWER-Use Column Profile View in Power Query Editor
Need to ensure column statistics are based on the analysis of an entire dataset -
ANSWER-From the status bar, change profiling status to entire dataset
Query named FactSales from SQL. Need to update the query to prevent new columns
that may be added to the table in the future from getting imported during data refreshes.
You select existing columns in the query. What two applied steps can you use in Power
Query Editor to achieve this goal?
Choose Columns
Remove Columns
Remove Other Columns
Transpose - ANSWER-Choose Columns, Remove Other Columns
From Power Query Editor, you import a CSV. Data includes ZIP. It is auto applied as
whole number. You need to ensure that ZIP is text with 5 character values. - ANSWER-
In Power Query Editor, update the current changed type step and replace convert from
number to text.
You connect Power Query Editor to a database table.
You need to remove the Row ID column. Your solution must ensure that new columns
do NOT display in the table model during a scheduled refresh in the future.
,What transformation should you use?
Select Row ID, then use the Remove Other Columns Command
Use the Remove Column command on the Row ID column
Use the select columns command and choose the columns to keep
use the transpose command then filter the rows to remove row id - ANSWER-Use
select columns command and choose columns to keep
only select columns command lets you choose columns to keep, delete columns you
don't want and prevent new columns from showing up
You have a fact table that contains sales data. The fact table includes a SalesDate
column. Auto date/time is disabled in global and current file options. You load table. You
need to ensure that you are able to analyze data using dates. Your solution must
minimize the model size and admin effort. - ANSWER-Add a separate date dimension
table
You upload reports to Power BI service and pin visuals to a dashboard. You plan to
create alert rules for several visuals. Where can you see alerts? - ANSWER-Email,
Microsoft Teams
You need to add new visuals to a Power BI Dashboard. This visual does not exist on a
report in the workspace. What should you do first? - ANSWER-Select Ask a question
about your data (Q&A can create a new visual without adding it to a report)
You plan to certify a Power BI dataset.
You need to identify at which level within your organization the permissions to certify a
dataset are assigned.
Which level should you identify?
Select only one answer.
Dataset
Tenant
Workbook
Workspace - ANSWER-Tenant
You manage a workspace in a shared capacity. The workspace contains a dataset
named DS1. How many consecutive refresh failures will automatically disable the
refresh? - ANSWER-4
You need to set a dataset as discoverable. Which 2 configurations will allow the dataset
to be marked as such? - ANSWER-Certify dataset, promote dataset
You need to delegate the task to schedule data refreshes. The solution must have the
principle of least privilege. What role should you use? - ANSWER-Contributor
Premium Workspace. What is the maximum number of refreshes that can be
, scheduled? - ANSWER-48
You plan to create a report in Desktop. You need to create a visualization that displays
data in 2 or more dimensions and cross-highlights with other visuals on the same report.
What type of visual? - ANSWER-Matrix
You plan to create a report in Power BI Desktop.
You need to identify the type of visualization that displays data as a set of nested
rectangles.
Which visualization should you use?
Bar Chart
Column Chart
Slicer
Treemap - ANSWER-Treemap
Need to create a visual that displays sales by employees, trending over months. The
visual must clearly show how employees are performing against each other and have a
ranking. What visual? - ANSWER-Ribbon chart.
You implement the Q&A feature in a report, so users can get answers to their questions
on their own.
You need to improve your Q&A search capabilities for end-users.
Which two configurations can you add? Each correct answer presents a complete
solution.
Add a linguistic schema
Add synonyms to model fields
Configure the dataset as a composite model
Organize the dataset columns and measures into logical folders in the fields pane -
ANSWER-Linguistics schema and synonyms to model fields
You are using Power BI Desktop to edit a stacked column chart that displays gross
sales data with a date hierarchy that contains year, quarter, month, and day.
You need to prevent users from viewing the hierarchy based on the year.
What should you do?
In the Filters pane, add a filter based on the quarter, month, and day.
In the Filters pane, add a filter based on the year.
In the Format pane, modify the Maximum Range setting.
In the Visualization pane, remove the year field from the date hierarchy fields in the X-
axis. - ANSWER-In the Visualization pane, remove the year field from the date
hierarchy fields in the X-axis.
You have a visual that is being cross-highlighted. By default, what data will be displayed
in a report tool tip? - ANSWER-The filtered (cross highlighted) data
