exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 3 question 56 discussion

Actual exam question from Microsoft's PL-300
Question #: 56
Topic #: 3
[All PL-300 Questions]

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 median line by using the Salary measure.

Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Sushvij
Highly Voted 2 years, 4 months ago
This question is in continuation of the series question # 22 of Topic 3. Answer is Yes We can definitely create a median line for the measure of salary (Tested) Also the other solution in this series is create a percentile line at 50% for the salary measure because percentile value at 50 % is exactly equal to the median value.
upvoted 47 times
ajvela
2 years ago
Yes ,tested, it's working
upvoted 8 times
...
Koalakueh
1 year, 5 months ago
Also, "Some question sets might have more than one correct solution". Even though the previous question's ans of "using the salary measure and setting 50% percentile" is a possible solution, this new option here can also be a possible solution
upvoted 1 times
...
...
JPGo
Highly Voted 2 years, 4 months ago
Selected Answer: A
This should work, not sure why not.
upvoted 7 times
...
sroumi
Most Recent 3 weeks, 2 days ago
Selected Answer: B
Simply using the Salary measure to add a median line won’t correctly compute the overall median salary across all employees. When you add a reference line based on the Salary measure, Power BI will typically aggregate (sum or average) the salary for each employee based on the context of the visual. It won’t automatically calculate the median value across all data.
upvoted 1 times
...
0002110
2 months, 2 weeks ago
Selected Answer: B
To create a reference line for showing which employees are above the median salary, you would need to calculate the median value of the Salary and then add that as a reference line to the chart. However, simply creating a median line by using the Salary measure itself would not necessarily give you the median value directly, since the Salary measure might be aggregated and doesn't directly calculate the median across employees. You would need to calculate the median of the Salary field.
upvoted 1 times
...
rcaliandro
8 months, 3 weeks ago
Selected Answer: A
A - Yes
upvoted 1 times
...
TrainingCA06
1 year, 1 month ago
THE ONLY WAY TO CREATE A You need to create a reference line in a clustered bar char is adding the percentile line, that is in the options on analytics, next right to the formatting icon.
upvoted 2 times
...
Dani_eL
1 year, 2 months ago
The answer is in the question: You need to create a reference line to show which employees are above the median salary. What would you use percentile when it talks about Median which readily available ?? Furthermore with percentile you need to expressly put the percentage which is not the case with median, median is median and that’s it.
upvoted 1 times
...
Dsbuff
1 year, 4 months ago
Selected Answer: A
A. Yes, creating a median line using the Salary measure in your clustered bar chart will meet the goal of showing which employees are above the median salary.
upvoted 1 times
...
Enrique67
1 year, 4 months ago
Debe crear una línea de referencia para mostrar qué empleados están por encima del salario medio. Salario medio no es lo mismo que mediana. La respuesta es la B. No
upvoted 1 times
...
ExamPage
1 year, 7 months ago
Selected Answer: A
Yes. See this shot video: https://www.projectpro.io/recipes/use-median-line-analytics-pane-power-bi
upvoted 1 times
...
MEG_Florida
1 year, 9 months ago
A. as median lines are references lines and would be at the 50% mark
upvoted 3 times
...
hungry85
2 years ago
A is correct because you create a median line which by itself is a 50th percertile
upvoted 3 times
...
quxxy
2 years, 3 months ago
I guess the thing is why "no" is correct is because previously we created percentile line at 50%... So newly created measure would work but it's creating is not necessary...
upvoted 5 times
Shalaleh
2 years ago
but questions are independent.
upvoted 2 times
...
Nawabi
2 years, 2 months ago
makes sense but dont know which one is right. if we consider linkage to previous questions you are right.
upvoted 2 times
...
...
mambamota
2 years, 3 months ago
Selected Answer: A
Should be A
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago