Power BI PL-300 Certification Exam
Questions & Answers (Grade A+)
There is a matrix using a standard date hierarchy. It is currently
showing a range of years. How do you display just a specific year
and that year's quarters? -
correct answer ✅Select 'Drill Down', and then the preferred data
point, which will drill down into the specific year and its quarters.
What pane allows the user to set the order that visuals move
between after pressing Tab? -
correct answer ✅Selection pane. It provides a list of all objects on
the current page and allows the user to group and hide visuals as
well as change the layer and tab order.
What Power Query feature removes spaces from the beginning and
the end of any string in a column? -
correct answer ✅Trim (Under Transform > Format). This removes
leading and trailing spaces from a string
What are two ways to add a custom visual from the online
Microsoft Store to a Power BI report? -
correct answer ✅Go to the Home tab, select More Visuals, and
select "From AppSource" or go the Insert tab, select the dropdown
containing all of the visuals, and select "Get more Visuals"
,Power BI PL-300 Certification Exam
Questions & Answers (Grade A+)
There is a dataset of Employee Data which includes the
'Department' and 'Salary' fields. To understand whether
Department has an influence on Salary, what two actions need to
be taken? There is a Key Influencers visual. -
correct answer ✅Drag Salary into the 'Analyze' section and
Department into the 'Explain By' section. The field in the Analyze
section is the numerical field that you are wanting to have
explained. The field(s) in the "Explain by" are the fields you want to
see have an influence.
What AI visual allows users to analyze data by drilling down into
various fields? -
correct answer ✅Decomposition Tree. The measure that is to be
broken down is placed into the Analyze section, and then how it is
to be broken down is placed in the Explain By section. This allows
users to drill-down into different related fields in their data model
and learn how they all influence each other.
When filtering a visual to values containing certain text, what
wildcard represents zero to many characters? For example, I want
to show all values starting with 'St' that include another 'T' -
correct answer ✅Asterisks (Example: St*t*)
,Power BI PL-300 Certification Exam
Questions & Answers (Grade A+)
What does Column Distribution in the Power Query editor show? -
correct answer ✅Unique and Distinct values
How are changes to an original column reflected in Duplicated and
Referenced columns, respectively? -
correct answer ✅Duplicating a query means that the query as it
currently is will be copied into another query. Subsequent changes
to the original query will not affect a duplicated query.
Referencing a query means that there is a link to the original query.
Subsequent changes to the original query will affect a referenced
query
Is a Power BI Pro license needed to use Sync Slicers? -
correct answer ✅No, it is not
What needs to be entered into the 'Starting Index' and 'Number of
Characters' fields in the Extract Text Range feature of the Power
Query Editor to extract the 3rd character from a field, and why? -
correct answer ✅Starting Index = 2, Number of Characters = 1
(Note STARTING INDEX = STARTING FROM)
The M language is zero-based. This means that the first character is
Index 0. Therefore, the third character is Index 2.
, Power BI PL-300 Certification Exam
Questions & Answers (Grade A+)
The Number of characters is how many characters you want to
return, not the final index.
What happens when the data type of a column that contains text
and numbers is changed to Decimal Number? -
correct answer ✅Any text (non-numerical) data returns an Error
There is a dataset which includes a Date field, and "Total Pay" and
"Department" fields.
There has been a visual which uses anomaly detection created.
Which type of visual is being used, and what fields could be used in
that visual? -
correct answer ✅A line chart, with a date field in the X-axis, Total
Pay in the Y-axis (the Legend section is empty).
Anomaly detection cannot be used on charts with legends or a
stacked column
What storage mode would help reduce a delay in visuals being
affected by slicers when the data used is from a SQL server? -
correct answer ✅Import storage mode, since the visuals changed
are based on data already loaded from the cache imported
Questions & Answers (Grade A+)
There is a matrix using a standard date hierarchy. It is currently
showing a range of years. How do you display just a specific year
and that year's quarters? -
correct answer ✅Select 'Drill Down', and then the preferred data
point, which will drill down into the specific year and its quarters.
What pane allows the user to set the order that visuals move
between after pressing Tab? -
correct answer ✅Selection pane. It provides a list of all objects on
the current page and allows the user to group and hide visuals as
well as change the layer and tab order.
What Power Query feature removes spaces from the beginning and
the end of any string in a column? -
correct answer ✅Trim (Under Transform > Format). This removes
leading and trailing spaces from a string
What are two ways to add a custom visual from the online
Microsoft Store to a Power BI report? -
correct answer ✅Go to the Home tab, select More Visuals, and
select "From AppSource" or go the Insert tab, select the dropdown
containing all of the visuals, and select "Get more Visuals"
,Power BI PL-300 Certification Exam
Questions & Answers (Grade A+)
There is a dataset of Employee Data which includes the
'Department' and 'Salary' fields. To understand whether
Department has an influence on Salary, what two actions need to
be taken? There is a Key Influencers visual. -
correct answer ✅Drag Salary into the 'Analyze' section and
Department into the 'Explain By' section. The field in the Analyze
section is the numerical field that you are wanting to have
explained. The field(s) in the "Explain by" are the fields you want to
see have an influence.
What AI visual allows users to analyze data by drilling down into
various fields? -
correct answer ✅Decomposition Tree. The measure that is to be
broken down is placed into the Analyze section, and then how it is
to be broken down is placed in the Explain By section. This allows
users to drill-down into different related fields in their data model
and learn how they all influence each other.
When filtering a visual to values containing certain text, what
wildcard represents zero to many characters? For example, I want
to show all values starting with 'St' that include another 'T' -
correct answer ✅Asterisks (Example: St*t*)
,Power BI PL-300 Certification Exam
Questions & Answers (Grade A+)
What does Column Distribution in the Power Query editor show? -
correct answer ✅Unique and Distinct values
How are changes to an original column reflected in Duplicated and
Referenced columns, respectively? -
correct answer ✅Duplicating a query means that the query as it
currently is will be copied into another query. Subsequent changes
to the original query will not affect a duplicated query.
Referencing a query means that there is a link to the original query.
Subsequent changes to the original query will affect a referenced
query
Is a Power BI Pro license needed to use Sync Slicers? -
correct answer ✅No, it is not
What needs to be entered into the 'Starting Index' and 'Number of
Characters' fields in the Extract Text Range feature of the Power
Query Editor to extract the 3rd character from a field, and why? -
correct answer ✅Starting Index = 2, Number of Characters = 1
(Note STARTING INDEX = STARTING FROM)
The M language is zero-based. This means that the first character is
Index 0. Therefore, the third character is Index 2.
, Power BI PL-300 Certification Exam
Questions & Answers (Grade A+)
The Number of characters is how many characters you want to
return, not the final index.
What happens when the data type of a column that contains text
and numbers is changed to Decimal Number? -
correct answer ✅Any text (non-numerical) data returns an Error
There is a dataset which includes a Date field, and "Total Pay" and
"Department" fields.
There has been a visual which uses anomaly detection created.
Which type of visual is being used, and what fields could be used in
that visual? -
correct answer ✅A line chart, with a date field in the X-axis, Total
Pay in the Y-axis (the Legend section is empty).
Anomaly detection cannot be used on charts with legends or a
stacked column
What storage mode would help reduce a delay in visuals being
affected by slicers when the data used is from a SQL server? -
correct answer ✅Import storage mode, since the visuals changed
are based on data already loaded from the cache imported
