- (Exam Topic 4)
You need to create a visualization that compares revenue and cost over time. Which type of visualization should you use?

1. A. stacked area chart
2. B. donut chart
3. C. line chart
4. D. waterfall chart

Correct Answer: C
A line chart or line graph displays the evolution of one or several numeric variables. Data points are connected by straight line segments. A line chart is often used to visualize a trend in data over intervals of time – a time series – thus the line is often drawn chronologically.
Example:

Reference:
https://www.data-to-viz.com/graph/line.html

- (Exam Topic 4)
Note: This question is part of a series of questions that use 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 the same in each question in this series.
You have a Microsoft SQL Server database that contains the following tables.

The following columns contain date information:
- Date[Month] in the mmyyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- Monthly_returns[Month_ID] in the mmyyyy format The Order table contains more than one million rows.
The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
You plan to use Power BI Desktop to create an analytics solution for the data.
You need to create a relationship between the Order table and the Store table on the Store_ID column.
What should you do before you create the relationship?

1. A. In the Order table query, use the Table.TrasformRows function.
2. B. In the Store table query, use the Table.TrasformRows function.
3. C. In the Store table query, use the Table.TrasformColumnTypes function.
4. D. In the Order table query, use the Table.TrasformColumnTypes function.

Correct Answer: C

- (Exam Topic 4)
You have the Power BI data model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 4)
You have a power BI tenant that hosts the datasets shown in the following table.

You have the following requirements:
• The export of reports that contain Personally Identifiable Information (Pll) must be prevented.
• Data used for financial decisions must be reviewed and approved before use.
For each of the following statements, select Yes if the statement is true. Otherwise select No. NOTE: Each correct selection is worth one point

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 4)
You have a Power BI report named Report' and a dashboard named Dashboard'. Report1 contains a line chart named Sales by month.
You pin the Sales by month visual to Dashboard1.
In Report1, you change the Sales by month visual to a bar chart. You need to ensure that the bar chart displays on Dashboard', What should you do?

1. A. Refresh the dataset used by Report1 and Dashboard1.
2. B. Select Refresh visuals for Dashboard1.
3. C. Edit the details for the dashboard tile Of Dashboar1.
4. D. Pin the Sales by month bar chart to Dashboard1.

Correct Answer: A