QUESTION: 133 Exam Topic: Question Set 3

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 section, you will NOT be able to return to it. As a result, these questions will not appear in 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?

Answer(s): B

Explanation:

Instead: You create a percentile line by using the Salary measure and set the percentile to 50%.
The median is the middle value or the 50th percentile of a data set.

Reference:

https://dash-intel.com/powerbi/statistical_functions_median.php

Reveal Solution Next Question

QUESTION: 134 Exam Topic: Question Set 3

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 section, you will NOT be able to return to it. As a result, these questions will not appear in 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 an average line by using the Salary measure.
Does this meet the goal?

Answer(s): B

Explanation:

Average is not Median.
Instead: You create a percentile line by using the Salary measure and set the percentile to 50%.
The median is the middle value or the 50th percentile of a data set.

Reference:

https://dash-intel.com/powerbi/statistical_functions_median.php

Reveal Solution Next Question

QUESTION: 135 Exam Topic: Question Set 3

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 section, you will NOT be able to return to it. As a result, these questions will not appear in 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?

Answer(s): A

Explanation:

The median is the middle value or the 50th percentile of a data set.

Reference:

https://dash-intel.com/powerbi/statistical_functions_median.php

Reveal Solution Next Question

QUESTION: 136 Exam Topic: Question Set 3

HOTSPOT (Drag and Drop is not supported)
You are profiling data by using Power Query Editor.
You have a table that contains a column named column1. Column statistics and Value distribution for column1 are 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.
Hot Area:

See Explanation section for answer.

Answer(s): A

Explanation:

Box 1: are 20 values that occur
There are 20 unique values.

Box 2: Elm, American
Elm, American is below Peer, flowering species in the graphic.

Reveal Solution Next Question

Free PL-300 Exam Braindumps (page: 34)

QUESTION: 133 Exam Topic: Question Set 3

Explanation:

Reference:

QUESTION: 134 Exam Topic: Question Set 3

Explanation:

Reference:

QUESTION: 135 Exam Topic: Question Set 3

Explanation:

Reference:

QUESTION: 136 Exam Topic: Question Set 3

Explanation: