Name: Score:
99 Multiple choice questions
Term 1 of 99
You need to add an analytics line to a visual. The value for the line must equal the result of a
DAX measure that always returns a consistent single value. The DAX measure must only be
used to populate the analytics line.
Which type of analytics line should you use?
Select only one answer.
Average line
Constant line
Max line
Min line
,Term 2 of 99
You need to prevent hidden date tables from being auto generated by Power BI Desktop for
every date or datetime data type column in a dataset.
What two tasks should you perform? Each correct answer presents a complete solution
Select all answers that apply.
a. Enable Mark as date table for the Calendar table.
b. From the Current File options in Power BI Desktop, disable Auto Date/Time
c. From the Global options in Power BI Desktop, disable Auto Date/Time for new files.
d. Set the Data Category to None for all Date and DateTime fields.
a. Enable Mark as date table for the Calendar table.
b. From the Current File options in Power BI Desktop, disable Auto Date/Time
a. Create a column that contains the time values for the start of the hour of the Reading
Time value.
d. Use the Group By functionality to aggregate the rows by hour, DateKey, and
LocationKey and then create an average Temp C value per row.
c. Disable the Display option.
d. Enable the Current Page option.
e. Enable the Data option.
c. Enable the script visuals option in the Visualization pane of Power BI Desktop.
Term 3 of 99
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 DAX function should you use in combination with the SUM function to override the
context and provide the result?
Select only one answer.
CALCULATE
FILTER
IGNORE
SUMX
,Term 4 of 99
You have a Power BI dataset that gets data from a table in a SQL Server database.
From which view in Power BI Desktop can you modify the storage mode of the table?
Select only one answer.
Data view
Model view
Page view
Report view
, Term 5 of 99
You have a Power BI Desktop dataset that includes a table named Employees containing a row
for each employee with the following columns:
Employee ID
Employee Name
Manager ID
Manager Name
You need to flatten the parent-child hierarchy in the Employees table by adding an extra
column that will contain a listing of employee IDs for all direct and indirect managers of each
employee.
Which two Data Analysis Expression (DAX) functions should you use? Each correct answer
presents part of the solution.
Select all answers that apply.
a. PATHCROSSJOIN
b. EXCEPT PATHITEM
c. EXCEPTPATH
d. PATHITEM CROSSJOIN
e. RELATED
c. EXCEPTPATH
d. PATHITEM CROSSJOIN
a. Calculated column
b. Column
c. Measure
a. Add a blank page to the PBIX file.
d. Each slicer must use the same column.
99 Multiple choice questions
Term 1 of 99
You need to add an analytics line to a visual. The value for the line must equal the result of a
DAX measure that always returns a consistent single value. The DAX measure must only be
used to populate the analytics line.
Which type of analytics line should you use?
Select only one answer.
Average line
Constant line
Max line
Min line
,Term 2 of 99
You need to prevent hidden date tables from being auto generated by Power BI Desktop for
every date or datetime data type column in a dataset.
What two tasks should you perform? Each correct answer presents a complete solution
Select all answers that apply.
a. Enable Mark as date table for the Calendar table.
b. From the Current File options in Power BI Desktop, disable Auto Date/Time
c. From the Global options in Power BI Desktop, disable Auto Date/Time for new files.
d. Set the Data Category to None for all Date and DateTime fields.
a. Enable Mark as date table for the Calendar table.
b. From the Current File options in Power BI Desktop, disable Auto Date/Time
a. Create a column that contains the time values for the start of the hour of the Reading
Time value.
d. Use the Group By functionality to aggregate the rows by hour, DateKey, and
LocationKey and then create an average Temp C value per row.
c. Disable the Display option.
d. Enable the Current Page option.
e. Enable the Data option.
c. Enable the script visuals option in the Visualization pane of Power BI Desktop.
Term 3 of 99
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 DAX function should you use in combination with the SUM function to override the
context and provide the result?
Select only one answer.
CALCULATE
FILTER
IGNORE
SUMX
,Term 4 of 99
You have a Power BI dataset that gets data from a table in a SQL Server database.
From which view in Power BI Desktop can you modify the storage mode of the table?
Select only one answer.
Data view
Model view
Page view
Report view
, Term 5 of 99
You have a Power BI Desktop dataset that includes a table named Employees containing a row
for each employee with the following columns:
Employee ID
Employee Name
Manager ID
Manager Name
You need to flatten the parent-child hierarchy in the Employees table by adding an extra
column that will contain a listing of employee IDs for all direct and indirect managers of each
employee.
Which two Data Analysis Expression (DAX) functions should you use? Each correct answer
presents part of the solution.
Select all answers that apply.
a. PATHCROSSJOIN
b. EXCEPT PATHITEM
c. EXCEPTPATH
d. PATHITEM CROSSJOIN
e. RELATED
c. EXCEPTPATH
d. PATHITEM CROSSJOIN
a. Calculated column
b. Column
c. Measure
a. Add a blank page to the PBIX file.
d. Each slicer must use the same column.
