PL-300 EXAM WITH QUALIFIED
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
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
