PL-300 Exam Questions & Answers
(Grade A+)
You need to identify the percentage of empty values in each
column as quickly as possible. What data preview option do you
select? -
correct answer ✅Column Quality
You need to identify outliers in a text column. Which data preview
option do you select? -
correct answer ✅Top and bottom values in Value Distribution
What is the relationship between the fact table and the dimension
tables? -
correct answer ✅Many to One
What kind of data is in a fact table? -
correct answer ✅Observational data (sales orders, shipping dates,
employees)
What kind of data is in a dimension table? -
correct answer ✅Specific entities like product IDs and calendar
dates, details about business entities
,PL-300 Exam Questions & Answers
(Grade A+)
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 -
correct 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?
,PL-300 Exam Questions & Answers
(Grade A+)
#date
#duration
List.Combine
List.Duration -
correct answer ✅#duration
What are 3 items that cannot be assigned a display folder? -
correct answer ✅Measure, Column, Calculated Column
To create a quick measure in Desktop, which 2 elements can you
use? -
correct answer ✅Calculations, Fields
What is a feature of implicit measure that explicit would not have? -
correct 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? -
correct answer ✅Performance Analyzer
, PL-300 Exam Questions & Answers
(Grade A+)
Where can you modify storage mode of tables? -
correct answer ✅Model view
2 Main Benefits of DirectQuery over Import? -
correct answer ✅Minimized need for data refresh, minimized local
disk space usage
2 Benefits of Import over Direct Query? -
correct 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? -
correct 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. -
correct answer ✅Use Column Profile View in Power Query Editor
Need to ensure column statistics are based on the analysis of an
entire dataset -
(Grade A+)
You need to identify the percentage of empty values in each
column as quickly as possible. What data preview option do you
select? -
correct answer ✅Column Quality
You need to identify outliers in a text column. Which data preview
option do you select? -
correct answer ✅Top and bottom values in Value Distribution
What is the relationship between the fact table and the dimension
tables? -
correct answer ✅Many to One
What kind of data is in a fact table? -
correct answer ✅Observational data (sales orders, shipping dates,
employees)
What kind of data is in a dimension table? -
correct answer ✅Specific entities like product IDs and calendar
dates, details about business entities
,PL-300 Exam Questions & Answers
(Grade A+)
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 -
correct 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?
,PL-300 Exam Questions & Answers
(Grade A+)
#date
#duration
List.Combine
List.Duration -
correct answer ✅#duration
What are 3 items that cannot be assigned a display folder? -
correct answer ✅Measure, Column, Calculated Column
To create a quick measure in Desktop, which 2 elements can you
use? -
correct answer ✅Calculations, Fields
What is a feature of implicit measure that explicit would not have? -
correct 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? -
correct answer ✅Performance Analyzer
, PL-300 Exam Questions & Answers
(Grade A+)
Where can you modify storage mode of tables? -
correct answer ✅Model view
2 Main Benefits of DirectQuery over Import? -
correct answer ✅Minimized need for data refresh, minimized local
disk space usage
2 Benefits of Import over Direct Query? -
correct 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? -
correct 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. -
correct answer ✅Use Column Profile View in Power Query Editor
Need to ensure column statistics are based on the analysis of an
entire dataset -
