PL-300 Free Practice Test

- (Exam Topic 4)
You are profiling data by using Power Query Editor.
You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data m State is 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 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 data model that analyzes product sales ever time. The data model contains the following tables.

A one-to-many relationship exists between the tables. The auto date/time option for the data model enabled.
You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.
Which two actions should you perform?

1. A. Option A
2. B. Option B
3. C. Option C
4. D. Option D

Correct Answer: AD

- (Exam Topic 4)
You have a report that includes a card visualization.
You need to apply the following conditional formatting to the card while minimizing design effort. For values that are greater than or equal to 100, the font of the data label must be dark red.
For values that are less than 100, the font of the data label must be dark gray. Which type of format should you use?

1. A. Color scale
2. B. Rules
3. C. Field value

Correct Answer: B

- (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