Name: Score:
165 Multiple choice questions
Term 1 of 165
You are creating a Power BI model to analyze inventory.
You load data into three tables named Date, Product, and Inventory.
The Inventory table relates to the Date and Product tables by using one-to-many relationships.
Inventory data is recorded daily with no exceptions. The correct inventory quantity for a given
product in a month is the last recorded value for that month.
What DAX function would complete the measure to show the correct inventory value when a
user analyzes inventory by year, month, or date?
Field Value
Userelationship
LastDate
Previousyear
Term 2 of 165
What visual allows you to add an average line as a reference line?
A Stacked Bar Chart
Append Queries
A Pie Chart
A Clustered Column Chart
,Term 3 of 165
What do Conditional Formatting icons in a table report display?
A series of icons (red, yellow, and green by default) based on the given values for the
chosen field
Unpivoting is the process of transforming specified column-based data into row-based
data
Import storage mode, since the visuals changed are based on data already loaded from
the cache imported
Displays Count, Error, Empty, Distinct, Unique, NaN, Zero, Min, Max, Average, and
Standard Deviation
Term 4 of 165
What does the Data option in an individual Bookmark's settings (three dots) determine? (when
selected vs. unselected)
DATESINPERIOD returns a table that contains a column of dates that begins with a
specified start date and continues for the specified number and type of date intervals
(days, months, years) and can be used to filter dates in a CALCULATE expression
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.
The HASONEVALUE function returns TRUE when the context for columnName has been
filtered down to one distinct value only. Otherwise is FALSE. This supports the use of
filtering down to a single value for a measure.
The Data option selected means that current filters are applied when the bookmark is
selected, whereas when the Data option is unselected, current filters are not applied
when the bookmark is selected
,Term 5 of 165
There is a Power BI model including a table called Departments, with a unique Department ID
column and a Department name column. There are four departments in the Departments table.
You need to ensure that users can see the data of their respective department only. What
should you do?
Create a departmentid parameter to filter the departments table
Create a Row-Level Security (RLS) role for each department, and then define the
membership of the role
Create a Date table and select 'Mark as Date Table' and then create a relationship
between the Date table and the Sales table to support the aforementioned sales. This
action will automatically disable the auto date/time option.
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
Term 6 of 165
There is a project management app that is fully hosted in MS Teams and was developed using
Microsoft Power Apps. You need to create a Power BI report that connects to the app. What
connector should you select?
Dataverse
Microsoft Teams Personal Analytics
Sql Server Database
Dataflows
, Term 7 of 165
How is Row-Level Security (RLS) configured?
A measure that cannot be added up over time. It can be summed across multiple
dimensions, but not all, such as time. One example is an inventory level, since it
represents a point in time
DATESINPERIOD returns a table that contains a column of dates that begins with a
specified start date and continues for the specified number and type of date intervals
(days, months, years) and can be used to filter dates in a CALCULATE expression
A scorecard is a metric that displays progress towards set KPIS from various teams and
departments into a single centralized visualization. One example is each region's
progress towards individual sales targets, and how that contributes to larger, overall
sales targets
Under the Modeling tab, select 'Manage Roles', select 'Create' to create the role, add a
name, then select the Table that you wish to add a field from, and then select the field
that you wish to filter by. For example, a user may select the SalesTerritory table, which
contains the SalesTerritoryCountry field, where the user may restrict the role to
'SalesTerritoryCountry = Germany' to restrict the data to rows related to the country of
Germany.
Term 8 of 165
A user attempts to use Power Query Editor to create a custom column using the expression =
#"Added Custom"{0}{Custom} and receives an error message "Cannot apply operator to types
Text and Number- Details: Operator = &, Left = A, Right = 1. What is the error caused by, and
what was the intended custom column?
The user does not have permission to the file and the referenced file was moved to a
new location
Get data from a sharepoint folder and enter the site url. select transform, then filter by
the folder path to the manufacturing reports library
The error message was caused by mismatched data types, attempting to create a
column with A1
Import storage mode, since the visuals changed are based on data already loaded from
the cache imported
165 Multiple choice questions
Term 1 of 165
You are creating a Power BI model to analyze inventory.
You load data into three tables named Date, Product, and Inventory.
The Inventory table relates to the Date and Product tables by using one-to-many relationships.
Inventory data is recorded daily with no exceptions. The correct inventory quantity for a given
product in a month is the last recorded value for that month.
What DAX function would complete the measure to show the correct inventory value when a
user analyzes inventory by year, month, or date?
Field Value
Userelationship
LastDate
Previousyear
Term 2 of 165
What visual allows you to add an average line as a reference line?
A Stacked Bar Chart
Append Queries
A Pie Chart
A Clustered Column Chart
,Term 3 of 165
What do Conditional Formatting icons in a table report display?
A series of icons (red, yellow, and green by default) based on the given values for the
chosen field
Unpivoting is the process of transforming specified column-based data into row-based
data
Import storage mode, since the visuals changed are based on data already loaded from
the cache imported
Displays Count, Error, Empty, Distinct, Unique, NaN, Zero, Min, Max, Average, and
Standard Deviation
Term 4 of 165
What does the Data option in an individual Bookmark's settings (three dots) determine? (when
selected vs. unselected)
DATESINPERIOD returns a table that contains a column of dates that begins with a
specified start date and continues for the specified number and type of date intervals
(days, months, years) and can be used to filter dates in a CALCULATE expression
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.
The HASONEVALUE function returns TRUE when the context for columnName has been
filtered down to one distinct value only. Otherwise is FALSE. This supports the use of
filtering down to a single value for a measure.
The Data option selected means that current filters are applied when the bookmark is
selected, whereas when the Data option is unselected, current filters are not applied
when the bookmark is selected
,Term 5 of 165
There is a Power BI model including a table called Departments, with a unique Department ID
column and a Department name column. There are four departments in the Departments table.
You need to ensure that users can see the data of their respective department only. What
should you do?
Create a departmentid parameter to filter the departments table
Create a Row-Level Security (RLS) role for each department, and then define the
membership of the role
Create a Date table and select 'Mark as Date Table' and then create a relationship
between the Date table and the Sales table to support the aforementioned sales. This
action will automatically disable the auto date/time option.
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
Term 6 of 165
There is a project management app that is fully hosted in MS Teams and was developed using
Microsoft Power Apps. You need to create a Power BI report that connects to the app. What
connector should you select?
Dataverse
Microsoft Teams Personal Analytics
Sql Server Database
Dataflows
, Term 7 of 165
How is Row-Level Security (RLS) configured?
A measure that cannot be added up over time. It can be summed across multiple
dimensions, but not all, such as time. One example is an inventory level, since it
represents a point in time
DATESINPERIOD returns a table that contains a column of dates that begins with a
specified start date and continues for the specified number and type of date intervals
(days, months, years) and can be used to filter dates in a CALCULATE expression
A scorecard is a metric that displays progress towards set KPIS from various teams and
departments into a single centralized visualization. One example is each region's
progress towards individual sales targets, and how that contributes to larger, overall
sales targets
Under the Modeling tab, select 'Manage Roles', select 'Create' to create the role, add a
name, then select the Table that you wish to add a field from, and then select the field
that you wish to filter by. For example, a user may select the SalesTerritory table, which
contains the SalesTerritoryCountry field, where the user may restrict the role to
'SalesTerritoryCountry = Germany' to restrict the data to rows related to the country of
Germany.
Term 8 of 165
A user attempts to use Power Query Editor to create a custom column using the expression =
#"Added Custom"{0}{Custom} and receives an error message "Cannot apply operator to types
Text and Number- Details: Operator = &, Left = A, Right = 1. What is the error caused by, and
what was the intended custom column?
The user does not have permission to the file and the referenced file was moved to a
new location
Get data from a sharepoint folder and enter the site url. select transform, then filter by
the folder path to the manufacturing reports library
The error message was caused by mismatched data types, attempting to create a
column with A1
Import storage mode, since the visuals changed are based on data already loaded from
the cache imported
