HOTSPOT
How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

What should you create to meet the reporting requirements of the sales department?

DRAG DROP
You are modeling data in a table named SalesDetail by using Microsoft Power Bl.
You need to provide end-users with access to the summary statistics about the SalesDetail data. The users require
insights on the completeness of the data and the value distributions.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions
to the answer area and arrange them in the correct order.
Select and Place:

HOTSPOT
You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance
sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the
appropriate
options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

You have a large dataset that contains more than 1 million rows. The table has a DateTime column named Date.
You need to reduce the size of the data model.
What should you do?

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:
1.
First name
2.
Last name
3.
Email address
4.
State/Region
5.
Phone number
You import the list into Power Query Editor.
You need to ensure that the list contains records for each State/Region to which you want to target a marketing
campaign.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains
a unique solution that might meet the stated goals. Some question sets might have more than one correct solution,
while others might not have a correct solution. After you answer a question in this scenario, you will NOT be able to
return to it. As a result, these questions will not appear on the review screen. You have a clustered bar chart that
contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars. You need to create a reference line to show which employees are above the
median salary. Solution: You create a constant line and set the value to .5.
Does this meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains
a unique solution that might meet the stated goals. Some question sets might have more than one correct solution,
while others might not have a correct solution. After you answer a question in this scenario, you will NOT be able to
return to it. As a result, these questions will not appear on the review screen. You have several reports and dashboards
in a workspace. You need to grant all organizational users to read access to a dashboard and several reports.
Solution: You publish an app to the entire organization. Does this meet the goal?

You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least
privilege. Which role should you assign to the user?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains
a unique solution that might meet the stated goals. Some question sets might have more than one correct solution,
while others might not have a correct solution. After you answer a question in this scenario, you will NOT be able to
return to it. As a result, these questions will not appear on the review screen. You have a clustered bar chart that
contains a measure named Salary as the value and a field named
Employee as the axis. Salary is present in the data as a numerical amount representing US dollars. You need to create a
reference line to show which employees are above the median salary.
Solution: You create a percentile line by using the Salary measure and set the percentile to 50%. Does this meet the
goal?

HOTSPOT
You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the
data are shown in the following table.

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct
selection is worth one point.
Hot Area:

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries
contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data
structure.
You need to load only the manufacturing reports to a table for analysis.
What should you do on Microsoft Power Bl Desktop?

You need to provide a solution to provide the sales managers with the required access. What should you include in the
solution?