Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam PL-300 Topic 1 Question 66 Discussion

Actual exam question for Microsoft's PL-300 exam
Question #: 66
Topic #: 1
[All PL-300 Questions]

Each employee has one manager as shown in the ParentEmployeelD column,

All reporting paths lead to the CEO at the top of the organizational hierarchy.

You need to create a calculated column that returns the count of levels from each employee to the CEO.

Which DAX expression should you use?

Show Suggested Answer Hide Answer
Suggested Answer: B

Contribute your Thoughts:

Johanna
18 days ago
Wow, this question is really making my head spin. I hope the exam doesn't have too many of these brain-teasers!
upvoted 0 times
...
Patrick
23 days ago
Option A seems a bit convoluted. I'm going to have to study this one a bit more before I can make a confident choice.
upvoted 0 times
Frederica
1 days ago
I think Option B might be the simpler choice.
upvoted 0 times
...
...
Rory
1 months ago
Option D looks like it's trying to do too much. I prefer a simpler solution that just focuses on the task at hand.
upvoted 0 times
Fletcher
7 days ago
Yeah, I also prefer a straightforward approach like Option A.
upvoted 0 times
...
Daisy
8 days ago
I think Option A might be a better choice for a simpler solution.
upvoted 0 times
...
Jeannine
15 days ago
I agree, Option D does seem a bit complicated.
upvoted 0 times
...
...
Gladis
1 months ago
Hmm, that's interesting. Can you explain why you think Option C is the best choice?
upvoted 0 times
...
Hannah
1 months ago
I disagree, I believe Option C is the correct DAX expression to use in this scenario.
upvoted 0 times
...
Filiberto
1 months ago
I think Option B is the way to go. It's more straightforward and easy to understand.
upvoted 0 times
Alberta
2 days ago
I'm leaning towards Option C, it seems like a good fit.
upvoted 0 times
...
Maxima
16 days ago
I think Option A might work better in this scenario.
upvoted 0 times
...
Willodean
29 days ago
I agree, Option B seems like the best choice.
upvoted 0 times
...
...
Wei
1 months ago
Option C looks good, but I'm not sure if it handles the edge cases where an employee has no manager or the CEO has no manager.
upvoted 0 times
...
Gladis
2 months ago
I think we should use Option B because it seems like the most logical choice.
upvoted 0 times
...

Save Cancel