Pl-300 Microsoft Practice Questions
In Power BI Desktop, you need to create a role.
Which two interfaces can you use? Each correct answer presents a complete
solution.
Select all answers that apply.
Data view
Model view
Report view
Page view
Power Query Editor - ANS - Model view
Report view
The Model view provides the ability to design and implement structure of a
dataset and include the option to create a role. The Report view provides the
ability to manage roles, including their creation. The Data view provides access to
data within a dataset Power Query Editor provides the ability to transform and
analyze data. The Page view is an option available from within the Report view
and is intended to simplify designing and building reports.
Implement row-level security - Training | Microsoft Learn
\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?
Select only one answer.
#date
#duration
List.Combine
List.Durations - ANS - #duration
The #duration function of the M language allows you to specify the datetime
values that will be entered into individual rows of a date table. The #date function
creates a date value based on the date parameters you specify. The
,List.Combine() combines multiple lists into one. List.Durations returns a list of
count duration values, rather than dates.
Create a date table - Training | Microsoft Learn
Power Query M function reference - PowerQuery M | Microsoft Learn
\Which native AI visual helps explain correlations for a metric within the dataset?
Select only one answer.
Q&A visual
Key influencers visual
Decomposition Tree visual
Smart Narrative visual - ANS - Key influencers visual
The Key influencers visual helps you understand correlated factors impacting a
particular metric. The Q&A visual allows end-users to ask natural language
questions to create AI generated charts based on the questions.
The Decomposition Tree visual lets you visualize data between multiple
dimensions and drill down in any order. The Smart Narrative visual lets you
combine natural language text with metrics from your model in sentence forms.
Find important factors with the Key influencers visual - Training | Microsoft Learn
\You are creating a report in a Power BI Desktop by using a dataset that contains
sales data.
You need to create a measure that always provides the value of total sales for the
year 2022, regardless of which year is selected in any visual in the same report.
Which Data Analysis Expression (DAX) function should you use in combination
with the SUM function to override the context and provide the result?
Select only one answer.
CALCULATE
IGNORE
FILTER
SUMX - ANS - CALCULATE
The CALCULATE function provides the result of the calculation with the ability to
override the context. The IGNORE function modifies the behavior of the
SUMMARIZECOLUMNS function by omitting specific expressions from the
BLANK/NULL evaluation. The FILTER function returns a table that represents a
subset of another table or expression. The SUMX function returns the sum of an
expression evaluated for each row in a table.
Use the Calculate function - Training | Microsoft Learn
\You are designing a data model in Power BI.
, You need to avoid introducing ambiguity into your data model design.
Which type of cardinality should you avoid?
Select only one answer.
one-to-one
one-to-many
many-to-one
many-to-many - ANS - many-to-many
Many-to-many cardinality in Power BI should be avoided due to ambiguity,
resulting from the presence of non-unique values. One-to-one cardinality in
Power BI should be avoided and, if present, should be eliminated by combining
the related tables. However, this type does not introduce ambiguity. One-to-many
and many-to-one cardinality are two common cardinality types, used for the
relationships between a fact and dimension tables.
Work with relationships and cardinality - Training | Microsoft Learn
\You are editing a Power BI Desktop report visual that displays gross sales data
with the hierarchy based on a year, quarter, month, and day.
You need to prevent users from viewing the hierarchy based on the year.
What should you do first?
Select only one answer.
In the Visualization pane, remove all date hierarchy fields from the Axis well.
In the Visualization pane, modify the Format visual Range settings.
In the Filters pane, add a filter based on the year.
In the Filters pane, add a filter based on the quarter, month, and day. - ANS - In
the Visualization pane, remove all date hierarchy fields from the Axis well.
To prevent users from viewing the hierarchy based on the year, you should first
remove all date hierarchy fields from the Axis well in the Visualization pane.
Modifying the Format visual Range settings in the Visualization pane would affect
the range of values displayed in the visual. Adding a filter based on the year in
the Filters pane would filter the values displayed in the visual. Adding a filter
based on the quarter, month, and day in the Filters pane would filter the values
displayed in the visual, but would not prevent users from viewing the hierarchy
based on the year.
Use basic interactions - Training | Microsoft Learn
\You are evaluating whether you need to create a dashboard in Power BI.
In which scenario do you need a dashboard instead of a report in Power BI?
Select only one answer.
In Power BI Desktop, you need to create a role.
Which two interfaces can you use? Each correct answer presents a complete
solution.
Select all answers that apply.
Data view
Model view
Report view
Page view
Power Query Editor - ANS - Model view
Report view
The Model view provides the ability to design and implement structure of a
dataset and include the option to create a role. The Report view provides the
ability to manage roles, including their creation. The Data view provides access to
data within a dataset Power Query Editor provides the ability to transform and
analyze data. The Page view is an option available from within the Report view
and is intended to simplify designing and building reports.
Implement row-level security - Training | Microsoft Learn
\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?
Select only one answer.
#date
#duration
List.Combine
List.Durations - ANS - #duration
The #duration function of the M language allows you to specify the datetime
values that will be entered into individual rows of a date table. The #date function
creates a date value based on the date parameters you specify. The
,List.Combine() combines multiple lists into one. List.Durations returns a list of
count duration values, rather than dates.
Create a date table - Training | Microsoft Learn
Power Query M function reference - PowerQuery M | Microsoft Learn
\Which native AI visual helps explain correlations for a metric within the dataset?
Select only one answer.
Q&A visual
Key influencers visual
Decomposition Tree visual
Smart Narrative visual - ANS - Key influencers visual
The Key influencers visual helps you understand correlated factors impacting a
particular metric. The Q&A visual allows end-users to ask natural language
questions to create AI generated charts based on the questions.
The Decomposition Tree visual lets you visualize data between multiple
dimensions and drill down in any order. The Smart Narrative visual lets you
combine natural language text with metrics from your model in sentence forms.
Find important factors with the Key influencers visual - Training | Microsoft Learn
\You are creating a report in a Power BI Desktop by using a dataset that contains
sales data.
You need to create a measure that always provides the value of total sales for the
year 2022, regardless of which year is selected in any visual in the same report.
Which Data Analysis Expression (DAX) function should you use in combination
with the SUM function to override the context and provide the result?
Select only one answer.
CALCULATE
IGNORE
FILTER
SUMX - ANS - CALCULATE
The CALCULATE function provides the result of the calculation with the ability to
override the context. The IGNORE function modifies the behavior of the
SUMMARIZECOLUMNS function by omitting specific expressions from the
BLANK/NULL evaluation. The FILTER function returns a table that represents a
subset of another table or expression. The SUMX function returns the sum of an
expression evaluated for each row in a table.
Use the Calculate function - Training | Microsoft Learn
\You are designing a data model in Power BI.
, You need to avoid introducing ambiguity into your data model design.
Which type of cardinality should you avoid?
Select only one answer.
one-to-one
one-to-many
many-to-one
many-to-many - ANS - many-to-many
Many-to-many cardinality in Power BI should be avoided due to ambiguity,
resulting from the presence of non-unique values. One-to-one cardinality in
Power BI should be avoided and, if present, should be eliminated by combining
the related tables. However, this type does not introduce ambiguity. One-to-many
and many-to-one cardinality are two common cardinality types, used for the
relationships between a fact and dimension tables.
Work with relationships and cardinality - Training | Microsoft Learn
\You are editing a Power BI Desktop report visual that displays gross sales data
with the hierarchy based on a year, quarter, month, and day.
You need to prevent users from viewing the hierarchy based on the year.
What should you do first?
Select only one answer.
In the Visualization pane, remove all date hierarchy fields from the Axis well.
In the Visualization pane, modify the Format visual Range settings.
In the Filters pane, add a filter based on the year.
In the Filters pane, add a filter based on the quarter, month, and day. - ANS - In
the Visualization pane, remove all date hierarchy fields from the Axis well.
To prevent users from viewing the hierarchy based on the year, you should first
remove all date hierarchy fields from the Axis well in the Visualization pane.
Modifying the Format visual Range settings in the Visualization pane would affect
the range of values displayed in the visual. Adding a filter based on the year in
the Filters pane would filter the values displayed in the visual. Adding a filter
based on the quarter, month, and day in the Filters pane would filter the values
displayed in the visual, but would not prevent users from viewing the hierarchy
based on the year.
Use basic interactions - Training | Microsoft Learn
\You are evaluating whether you need to create a dashboard in Power BI.
In which scenario do you need a dashboard instead of a report in Power BI?
Select only one answer.
