Name: Score:
76 Multiple choice questions
Term 1 of 76
Implicit measures are...
Benefits with implicit measures...
Calculated tables are best for intermediate calculations and data you want to store as
part of the model.
automatic behaviors that allow visuals to summarize model column data.
Several benefits are associated with implicit measures. Implicit measures are simple
concepts to learn and use, and they provide flexibility in the way that report authors
visualize model data. Additionally, they mean less work for you as a data modeler
because you don't have to create explicit calculations.
Date
Decimal Number
Date data types display well on a continuous (range) axis where report users understand
chronological order. Number data types display well on a continuous (range) axis where
report users understand the order between min and max values. Binary data and text
(categorical) data cannot be displayed on a continuous (range) axis. Date, time, or
number are the only data types comparable with a continuous axis.
Disable the Data option.
Disable the Current Page option.
Enable the Display option.
The current page capture allows the bookmark to navigate back to the page of capture.
The data capture updates filters and drillthrough which should not occur for this
bookmark. The display capture updates visual visibility on the report page.
,Term 2 of 76
What does the Value distribution graph present?
Counts for each unique value in a specific column.
Averages of all numerical entries across multiple columns.
Summaries of categorical data without specific counts.
Trends over time for a selected dataset.
Term 3 of 76
You plan to create a Power BI workspace.
You need to ensure that you will be able to configure a Microsoft 365 group whose SharePoint
Online document library is available to workspace users once the workspace is created.
Which setting (1) should you configure when creating the workspace?
Allow contributors to update the app
Develop a template app
License mode
Workspace OneDrive
,Term 4 of 76
You need to reduce the size of a Power BI model that contains two dimension tables named
Date and Location, and one fact table named Temperatures. The Temperatures table contains
the following fields:
Reading Time (datetime)
DateKey (date)
LocationKey (whole number)
Temp C (decimal)
You have one row for every 5-minute interval for each location. The Temperatures table is
related to the Date and Location dimensions by using many-to-one relationships. You need to
reduce the cardinality of the table. The solution must ensure that the dataset supports reports
that analyze average temperature by hour and location.
What two actions should you perform? Each correct answer presents part of the solution.
1. Create a column that contains the time values for the start of the hour of the Reading
Time value.
2. Disable the query load on the Temperatures query in the Power Query Editor.
3. Remove the rows that occur exactly at 0
Term 5 of 76
You have a Power BI Premium per user workspace.
What is the maximum number of refreshes that can be scheduled each day?
Select only one answer.
1
8
16
48
, Term 6 of 76
You have a Power BI model.
You need to assign items to a display folder.
Which three items can be assigned to a display folder? Each correct answer presents part of
the solution.
Calculated column
Column
Measure
Report
Table
8
The maximum number of refreshes per day for a Power BI workspace in a shared
capacity is 8.
Calculated column
Column
Measure
Tables and reports cannot be assigned a display folder. Columns, calculated columns,
and measures can be assigned a display folder.
48
In a Premium per user workspace the limit is 48 refreshes per day for a dataset.
Admin
The Admin role is the only one that has the permission to update workspace metadata.
76 Multiple choice questions
Term 1 of 76
Implicit measures are...
Benefits with implicit measures...
Calculated tables are best for intermediate calculations and data you want to store as
part of the model.
automatic behaviors that allow visuals to summarize model column data.
Several benefits are associated with implicit measures. Implicit measures are simple
concepts to learn and use, and they provide flexibility in the way that report authors
visualize model data. Additionally, they mean less work for you as a data modeler
because you don't have to create explicit calculations.
Date
Decimal Number
Date data types display well on a continuous (range) axis where report users understand
chronological order. Number data types display well on a continuous (range) axis where
report users understand the order between min and max values. Binary data and text
(categorical) data cannot be displayed on a continuous (range) axis. Date, time, or
number are the only data types comparable with a continuous axis.
Disable the Data option.
Disable the Current Page option.
Enable the Display option.
The current page capture allows the bookmark to navigate back to the page of capture.
The data capture updates filters and drillthrough which should not occur for this
bookmark. The display capture updates visual visibility on the report page.
,Term 2 of 76
What does the Value distribution graph present?
Counts for each unique value in a specific column.
Averages of all numerical entries across multiple columns.
Summaries of categorical data without specific counts.
Trends over time for a selected dataset.
Term 3 of 76
You plan to create a Power BI workspace.
You need to ensure that you will be able to configure a Microsoft 365 group whose SharePoint
Online document library is available to workspace users once the workspace is created.
Which setting (1) should you configure when creating the workspace?
Allow contributors to update the app
Develop a template app
License mode
Workspace OneDrive
,Term 4 of 76
You need to reduce the size of a Power BI model that contains two dimension tables named
Date and Location, and one fact table named Temperatures. The Temperatures table contains
the following fields:
Reading Time (datetime)
DateKey (date)
LocationKey (whole number)
Temp C (decimal)
You have one row for every 5-minute interval for each location. The Temperatures table is
related to the Date and Location dimensions by using many-to-one relationships. You need to
reduce the cardinality of the table. The solution must ensure that the dataset supports reports
that analyze average temperature by hour and location.
What two actions should you perform? Each correct answer presents part of the solution.
1. Create a column that contains the time values for the start of the hour of the Reading
Time value.
2. Disable the query load on the Temperatures query in the Power Query Editor.
3. Remove the rows that occur exactly at 0
Term 5 of 76
You have a Power BI Premium per user workspace.
What is the maximum number of refreshes that can be scheduled each day?
Select only one answer.
1
8
16
48
, Term 6 of 76
You have a Power BI model.
You need to assign items to a display folder.
Which three items can be assigned to a display folder? Each correct answer presents part of
the solution.
Calculated column
Column
Measure
Report
Table
8
The maximum number of refreshes per day for a Power BI workspace in a shared
capacity is 8.
Calculated column
Column
Measure
Tables and reports cannot be assigned a display folder. Columns, calculated columns,
and measures can be assigned a display folder.
48
In a Premium per user workspace the limit is 48 refreshes per day for a dataset.
Admin
The Admin role is the only one that has the permission to update workspace metadata.
