exam questions

Exam DA-100 All Questions

View all questions & answers for the DA-100 exam

Exam DA-100 topic 3 question 21 discussion

Actual exam question from Microsoft's DA-100
Question #: 21
Topic #: 3
[All DA-100 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 scenario, 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 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
aclacl
Highly Voted 4 years ago
Correct answer is A. True
upvoted 45 times
...
woody79
Highly Voted 3 years, 6 months ago
should be B. I created the median measure MEDIAN(EmployeeTable[Salary]) and used it in the visual, it gave me another bar for each employee not a reference median line. To create that I had to use the analytics pane and median from it. Then I got a reference line at 50%.
upvoted 9 times
Angell
2 years, 10 months ago
It is A. Solution states: "You create a median line by using the Salary measure.". You're saying you created a median MEASURE. Also bear in mind that the measure that is already created just shows the salary, so inserting a median LINE based on this measure won't jam the analysis.
upvoted 7 times
...
alenashkel_
2 years, 5 months ago
median line is not a measure. It's in analytics.
upvoted 1 times
...
...
iccent2
Most Recent 2 years, 6 months ago
Has anyone sat for the PL-300 exam within the past two months from Sept 1, 2022?
upvoted 1 times
...
[Removed]
2 years, 7 months ago
A is correct Tested. It means to add a median line from visual analytics. When adding the median line, PowerBI considers by default the first measure of the clustered bar chart. However, you can add multiple measures in the value section, so you need to choose which measure to use for calculating the median. That's why it's mentioned in the answer "by using the Salary measure"
upvoted 1 times
...
QWERTYman
2 years, 8 months ago
Selected Answer: A
Answer is A
upvoted 1 times
...
QWERTYman
2 years, 8 months ago
Selected Answer: A
Answer is A
upvoted 1 times
...
sparban
2 years, 9 months ago
Yes, the answer is A. The question said Median line not median measure, and I can configure median line in "add further analysis"
upvoted 1 times
...
edriska1
2 years, 9 months ago
on exam 7/11/22 my answer was A
upvoted 2 times
...
Tested as A
upvoted 1 times
moniqbk
2 years, 11 months ago
how did you test, could you explain? Cause when I create measure, it didnt give me any reference line for all empl.
upvoted 1 times
...
...
dgoo7
3 years, 1 month ago
Selected Answer: A
I think its A
upvoted 2 times
...
w0mz
3 years, 1 month ago
Selected Answer: B
It's B (false) because the median measure will create a separate median value relative to each employee. The measure will not show a constant median line where y=x.
upvoted 1 times
...
datavan
3 years, 1 month ago
Selected Answer: B
B. A measure will result a different value for each employee.
upvoted 2 times
...
TechDiva
3 years, 1 month ago
I got it on my exam 03/17/2022. 90-95% questions were from here. 61 questions in 100 min. All 3 case studies that appeared in exam, where from here.
upvoted 1 times
TechDiva
3 years, 1 month ago
Ansered: Yes
upvoted 2 times
...
...
MOONDRE
3 years, 1 month ago
Selected Answer: A
Yes You can watch the video to understand the reason behind : https://www.youtube.com/watch?v=JTSild7vikA
upvoted 5 times
BLUE_BUBBLES
2 years, 11 months ago
This is not in English.
upvoted 1 times
Davico93
2 years, 9 months ago
what do you mean?
upvoted 1 times
...
...
...
JordiJordi
3 years, 1 month ago
Selected Answer: B
Not possible, B!
upvoted 1 times
...
MagnusFA
3 years, 1 month ago
Selected Answer: B
Please check woody79 comment
upvoted 3 times
sgodd_0298
2 years, 9 months ago
Please check comments under woody79. They do not ask you to create a median measure, they ask you to add in a median line using a measure already created. Therefore Woody79 explanation is invalid for this question. Answer is A.
upvoted 1 times
...
...
Ashley090521
3 years, 2 months ago
on exam 3/1/2022
upvoted 1 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