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?

AOption A

BOption B

Coption C

DOption D

Show Suggested Answer

Suggested Answer: B

by Margurite at Apr 05, 2025, 03:37 AM

Limited Time Offer

25%

Off

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Johanna

2 months 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

2 months 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

Han

23 days ago

Let's go with Option B then.

upvoted 0 times

...

Izetta

1 months ago

I agree, Option B looks like the most straightforward solution.

upvoted 0 times

...

Frederica

2 months ago

I think Option B might be the simpler choice.

upvoted 0 times

...

Rory

3 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

2 months ago

Yeah, I also prefer a straightforward approach like Option A.

upvoted 0 times

...

Daisy

2 months ago

I think Option A might be a better choice for a simpler solution.

upvoted 0 times

...

Jeannine

2 months ago

I agree, Option D does seem a bit complicated.

upvoted 0 times

...

Gladis

3 months ago

Hmm, that's interesting. Can you explain why you think Option C is the best choice?

upvoted 0 times

...

Hannah

3 months ago

I disagree, I believe Option C is the correct DAX expression to use in this scenario.

upvoted 0 times

...

Filiberto

3 months ago

I think Option B is the way to go. It's more straightforward and easy to understand.

upvoted 0 times

Yun

2 months ago

I believe Option D is the most efficient solution.

upvoted 0 times

...

Alberta

2 months ago

I'm leaning towards Option C, it seems like a good fit.

upvoted 0 times

...

Maxima

2 months ago

I think Option A might work better in this scenario.

upvoted 0 times

...

Willodean

3 months ago

I agree, Option B seems like the best choice.

upvoted 0 times

...

Wei

3 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

4 months ago

I think we should use Option B because it seems like the most logical choice.

upvoted 0 times

...