You need to create a visualization that compares revenue and cost over time.
Which type of visualization should you use?

• A.stacked area chart
• B.donut chart
• C.line chart
• 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:

Incorrect Answers:
A: Stacked area charts are not appropriate to study the evolution of each individual group: it is very hard to substract the height of other groups at each time point.
Note: A stacked area chart is the extension of a basic area chart. It displays the evolution of the value of several groups on the same graphic. The values of each group are displayed on top of each other, what allows to check on the same figure the evolution of both the total of a numeric variable, and the importance of each group.
Reference:
https://www.data-to-viz.com/graph/line.html

Comment: *

Name: *

Email: *

Verification: *

You view a query named Transactions as shown in the following exhibit.

The query gets CSV files from a folder.
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.

Correct Answer:

Reference:
https://pediaa.com/what-is-the-difference-between-unique-and-distinct-in-sql/#:~:text=Unique%20and%20Distinct%20are%20two%20SQL%20constraints.,the%20records%20from%20a%20table.

Comment: *

Name: *

Email: *

Verification: *

You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter?
To answer, select the appropriate options in the answer area.
NOTE; Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have multiple dashboards.
You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design.
What should you use?

• A.comments
• B.tiles
• C.Microsoft Information Protection sensitivity labels
• D.Active Directory groups

Comment: *

Name: *

Email: *

Verification: *

Your company has affiliates who help the company acquire customers.
You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.
The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.

You need to develop a measure to support the visual.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax

Comment: *

Name: *

Email: *

Verification: *