Methods used to create aggregations - ANSWER - Aggregations can be created by using
Power Query Editor in Power BI Desktop
- If you have access to the database, the summary can be created by creating a table with
the summary and then importing the table into Power BI Desktop
- If you have access to the database, the aggregation can be created by creating a view for
the aggregation and then importing the view into Power BI Desktop
What does it mean to "assume referential integrity" when developing relationships between
tables in Power BI Desktop? - ANSWER The Require Referential Integrity setting causes
queries to use INNER JOIN statements instead of OUTER JOIN statements, which increases
the efficiency of the query
What are the different privacy level settings in Power BI desktop? - ANSWER Private, pub-
lic, and organizational
What are the different Microsoft 365 sensitivity labels? - ANSWER Highly confidential,
confidential, general, personal, and none
What are the valid types in the M programming language? - ANSWER Record, list, func-
tion, table, nullable, type
What are the mandatory parameters in the DAX function PathItem? - ANSWER - The first
is the text path describing the hierarchy
- The second is the level you want to be returned
What do you need to register an app for embedding Power BI content? - ANSWER A
Power BI Pro license
1
,Which is a way to improve performance when retrieving data in Power BI? - ANSWER
Perform some calculations in the original data source
For which purposes would you recommend using the decomposition tree? - ANSWER - To
perform a root cause analysis
- To automatically analyze the selected dimensions to check where the metric has the lowest
or highest value
- To visualize the data across multiple dimensions
What are the mandatory parameters in the DAX function LOOKUPVALUE? - ANSWER -
The name of the field you're interested in
- The field with the value we're searching for
- The value we want to match on
Which Power BI license type is the standard license required for most Power BI development
work? - ANSWER Pro
What are the requirements for an Incremental Refresh? - ANSWER - RangeStart and
RangeEnd are two PowerQuery parameters needed for incremental refresh
- A date field is required in a table in the dataset
- Use the Incremental Refresh feature only for data sources that support query folding
What is true about calculated columns? - ANSWER - A calculated column is populated
when it's creating
- Adds to the dataset size
- Its values are updated when the dataset is refreshed
- Its values are stored in the Power BI dataset like those of a standard column
2
, What is the order of phases of Power BI report creation? - ANSWER Development, test,
production
What elements can you save in a bookmark? - ANSWER - The current page - Filters - Slic-
ers (including slicer type and state) - Visual selection state - Sort order - Drill location - Visi-
bility of an object - The focus or spotlight mode of any visible object
Which option would you use in Power BI to split your query into two parts? - ANSWER
Extract previous
For what reasons is the Lineage view in Power BI important? - ANSWER - Saves time by
simplifying your task of identifying reports and dashboards that haven't been refreshed
- Allows you to manage your workspaces and observe the impact of a single change in one
dataset to reports and dashboards
- Simplifies the troubleshooting process because you can see the path that the data takes
from source to destination and determine pain points and bottlenecks
Which is true about the Slicer Visual in a Power BI report? - ANSWER - You can configure
the Slicer Visual based on the date column to use sliders
- The purpose of using a Slicer Visual in Power BI reports is to provide an interactive filtering
experience for report consumers
Which tool would you use to create Power BI reports which are to be deployed to Power BI
Report Server? - ANSWER Power BI Desktop optimized for Report Server
Which three parameters are required in the API requests for training and inference? - AN-
SWER startTime, endTime, and source
Which Power BI license type enables Power BI content to be hosted on a custom application
outside the Power BI web portal? - ANSWER Embedded
3
Power Query Editor in Power BI Desktop
- If you have access to the database, the summary can be created by creating a table with
the summary and then importing the table into Power BI Desktop
- If you have access to the database, the aggregation can be created by creating a view for
the aggregation and then importing the view into Power BI Desktop
What does it mean to "assume referential integrity" when developing relationships between
tables in Power BI Desktop? - ANSWER The Require Referential Integrity setting causes
queries to use INNER JOIN statements instead of OUTER JOIN statements, which increases
the efficiency of the query
What are the different privacy level settings in Power BI desktop? - ANSWER Private, pub-
lic, and organizational
What are the different Microsoft 365 sensitivity labels? - ANSWER Highly confidential,
confidential, general, personal, and none
What are the valid types in the M programming language? - ANSWER Record, list, func-
tion, table, nullable, type
What are the mandatory parameters in the DAX function PathItem? - ANSWER - The first
is the text path describing the hierarchy
- The second is the level you want to be returned
What do you need to register an app for embedding Power BI content? - ANSWER A
Power BI Pro license
1
,Which is a way to improve performance when retrieving data in Power BI? - ANSWER
Perform some calculations in the original data source
For which purposes would you recommend using the decomposition tree? - ANSWER - To
perform a root cause analysis
- To automatically analyze the selected dimensions to check where the metric has the lowest
or highest value
- To visualize the data across multiple dimensions
What are the mandatory parameters in the DAX function LOOKUPVALUE? - ANSWER -
The name of the field you're interested in
- The field with the value we're searching for
- The value we want to match on
Which Power BI license type is the standard license required for most Power BI development
work? - ANSWER Pro
What are the requirements for an Incremental Refresh? - ANSWER - RangeStart and
RangeEnd are two PowerQuery parameters needed for incremental refresh
- A date field is required in a table in the dataset
- Use the Incremental Refresh feature only for data sources that support query folding
What is true about calculated columns? - ANSWER - A calculated column is populated
when it's creating
- Adds to the dataset size
- Its values are updated when the dataset is refreshed
- Its values are stored in the Power BI dataset like those of a standard column
2
, What is the order of phases of Power BI report creation? - ANSWER Development, test,
production
What elements can you save in a bookmark? - ANSWER - The current page - Filters - Slic-
ers (including slicer type and state) - Visual selection state - Sort order - Drill location - Visi-
bility of an object - The focus or spotlight mode of any visible object
Which option would you use in Power BI to split your query into two parts? - ANSWER
Extract previous
For what reasons is the Lineage view in Power BI important? - ANSWER - Saves time by
simplifying your task of identifying reports and dashboards that haven't been refreshed
- Allows you to manage your workspaces and observe the impact of a single change in one
dataset to reports and dashboards
- Simplifies the troubleshooting process because you can see the path that the data takes
from source to destination and determine pain points and bottlenecks
Which is true about the Slicer Visual in a Power BI report? - ANSWER - You can configure
the Slicer Visual based on the date column to use sliders
- The purpose of using a Slicer Visual in Power BI reports is to provide an interactive filtering
experience for report consumers
Which tool would you use to create Power BI reports which are to be deployed to Power BI
Report Server? - ANSWER Power BI Desktop optimized for Report Server
Which three parameters are required in the API requests for training and inference? - AN-
SWER startTime, endTime, and source
Which Power BI license type enables Power BI content to be hosted on a custom application
outside the Power BI web portal? - ANSWER Embedded
3
