Udemy Power BI UPDATED ACTUAL
Exam Questions and CORRECT Answers
False: we will be creating all of our table relationships from scratch throughout the course, so we
don't want Power BI to automatically add relationships for us. - CORRECT ANSWER -
The "Autodetect New Relationships" option should be enabled for this course.
Report, Data, Relationships (aka Model) - CORRECT ANSWER - What are the three core
views in Power BI desktop?
Table relationships are formed - CORRECT ANSWER - In the typical Power BI
workflow, which of the following takes place after data is loaded but before reports are built?
Stream your favorite 90's jams - CORRECT ANSWER - Which of the following are you
not able to do with Power BI Desktop?
English (United States) - CORRECT ANSWER - Which locale should be selected in the
Regional Settings, for the purposes of this course?
All of these can be found in both "Power Excel" and Power BI
-Query editing tools
-DAX measures
-Data modeling tools - CORRECT ANSWER - Which of the following can be found in
both "Power Excel" and Power BI?
False: log-in is only required to publish reports and access sharing and collaboration tools
(Power BI Service) - CORRECT ANSWER - A log-in is required to use Power BI
Desktop.
Home, Transform, Add Column - CORRECT ANSWER - Which three tabs in the Query
Editor contain data shaping and transformation tools?
, True: the "Transform" tools overwrites values, while the "Add Column" tools create new ones -
CORRECT ANSWER - The Query Editor "Transform" tools overwrite the existing values
in a column.
False: Statistic tools are only available to use from the Transform tab in the Query Editor -
CORRECT ANSWER - Statistic tools are accessible from the Add Column tab in the
Query Editor.
When you want to make sure that your text doesn't have leading or trailing spaces. - CORRECT
ANSWER - In which scenario would the Trim tool be most helpful?
Latest: returns a single value (like statistical functions), and can only be accessed from the
Transform tab - CORRECT ANSWER - Which of the following date tools is only
available in the Transform tab of the Query Editor?
True: Merging adds columns, appending adds rows - CORRECT ANSWER - Merging
queries makes tables wider by adding columns, and appending queries makes tables longer by
adding rows.
Unpivoting: transforms a table from a horizontal orientation to a vertical orientation by turning
distinct column values into rows - CORRECT ANSWER - Which term best describes the
process of transforming a table form a horizontal orientation to a vertical orientation by turning
distinct column values into rows?
True: all queries will be included in report refresh by default, and must be manually excluded. -
CORRECT ANSWER - All queries in a Power BI file will refresh by default.
Index: columns can be used to generate sequential lists of unique values - CORRECT
ANSWER - Which type of column would you add to create a series of values that uniquely
identify each row?
Exam Questions and CORRECT Answers
False: we will be creating all of our table relationships from scratch throughout the course, so we
don't want Power BI to automatically add relationships for us. - CORRECT ANSWER -
The "Autodetect New Relationships" option should be enabled for this course.
Report, Data, Relationships (aka Model) - CORRECT ANSWER - What are the three core
views in Power BI desktop?
Table relationships are formed - CORRECT ANSWER - In the typical Power BI
workflow, which of the following takes place after data is loaded but before reports are built?
Stream your favorite 90's jams - CORRECT ANSWER - Which of the following are you
not able to do with Power BI Desktop?
English (United States) - CORRECT ANSWER - Which locale should be selected in the
Regional Settings, for the purposes of this course?
All of these can be found in both "Power Excel" and Power BI
-Query editing tools
-DAX measures
-Data modeling tools - CORRECT ANSWER - Which of the following can be found in
both "Power Excel" and Power BI?
False: log-in is only required to publish reports and access sharing and collaboration tools
(Power BI Service) - CORRECT ANSWER - A log-in is required to use Power BI
Desktop.
Home, Transform, Add Column - CORRECT ANSWER - Which three tabs in the Query
Editor contain data shaping and transformation tools?
, True: the "Transform" tools overwrites values, while the "Add Column" tools create new ones -
CORRECT ANSWER - The Query Editor "Transform" tools overwrite the existing values
in a column.
False: Statistic tools are only available to use from the Transform tab in the Query Editor -
CORRECT ANSWER - Statistic tools are accessible from the Add Column tab in the
Query Editor.
When you want to make sure that your text doesn't have leading or trailing spaces. - CORRECT
ANSWER - In which scenario would the Trim tool be most helpful?
Latest: returns a single value (like statistical functions), and can only be accessed from the
Transform tab - CORRECT ANSWER - Which of the following date tools is only
available in the Transform tab of the Query Editor?
True: Merging adds columns, appending adds rows - CORRECT ANSWER - Merging
queries makes tables wider by adding columns, and appending queries makes tables longer by
adding rows.
Unpivoting: transforms a table from a horizontal orientation to a vertical orientation by turning
distinct column values into rows - CORRECT ANSWER - Which term best describes the
process of transforming a table form a horizontal orientation to a vertical orientation by turning
distinct column values into rows?
True: all queries will be included in report refresh by default, and must be manually excluded. -
CORRECT ANSWER - All queries in a Power BI file will refresh by default.
Index: columns can be used to generate sequential lists of unique values - CORRECT
ANSWER - Which type of column would you add to create a series of values that uniquely
identify each row?
