Note: This question is a part of a series of questions that present the same scenario. For
your convenience, the scenario is repeated in each question. Each question presents a
different goal and answer choices, but the text of the scenario is exactly the same in each
question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that has the tables shown in the Database
Diagram exhibit. (Click the Exhibit.)

Which DAX formula should you use?

You have a collection of reports for the HR department of your company.
You need to create a visualization for the HR department that shows a historic employee
counts and predicts trends during the next six months.
Which type of visualization should you use?

You are building a Power BI report to analyze customer segments.
You need to identify customer segments dynamically based on the Bounce Rate across
dimensions such as source, geography, and demographics. The solution must minimize
analysis effort.
Which type of visualization should you use?

You have a Power Bi report for the procurement department. The report contains data from the following tables.

You import a Power Bl dataset that contains the following tables:

• Date
• Product
• Product Inventory

The Product inventory table contains 25 million rows. A sample of the data is shown in the following table.

The Product Inventory table relates to the Date table by using the DateKey column. The Product inventory table relates to the Product table by using the ProductKey column. You need to reduce the size of the data model without losing information. What should you do?

You have a dataset named Pens that contains the following columns:
Unit Price
Quantity Ordered
You need to create a visualization that shows the relationship between Unit Price and
Quantity Ordered. The solution must highlight orders that have a similar unit price and
ordered quantity.
Which type of visualization and which feature should you use? To answer, select the
appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You have a dataset that is used infrequently and refreshes every hour.
You receive a notification that the refresh was disabled due to inactivity.
Which two actions will cause the scheduled refresh schedule to resume? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

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.