SAP C_THR92_2505 Exam - Topic 7 Question 3 Discussion

Actual exam question for SAP's C_THR92_2505 exam

Question #: 3
Topic #: 7

In the Advanced Reporting tool, you want to create a query that includes the employee's matrix manager. When you configure the table join with the Job Relationships table, the Results tab displays multiple rows per employee that also include relationships to HR managers and second managers. How do you configure the query to return one row per employee that shows the employee's matrix manager, when assigned?

AChange the Job Relationship join to an inner join.

BChange the Job Relationship to include a table restriction.

CChange the Job Relationship join to a right join.

DChange the Job Relationship join to a left join.

Show Suggested Answer

Suggested Answer: B

by Tawna at Aug 03, 2025, 12:26 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Mari

2 months ago

Not sure if a table restriction is enough to solve this.

upvoted 0 times

...

Sylvie

2 months ago

I think B is the better option here.

upvoted 0 times

...

Annamae

3 months ago

A left join should work for this!

upvoted 0 times

...

Maia

3 months ago

Wait, why would you use a right join? That seems off.

upvoted 0 times

...

Dean

3 months ago

Totally agree with Annamae, left join is the way to go!

upvoted 0 times

...

Frank

3 months ago

Right joins seem less common in our practice questions. I don't think that's what we want for this scenario.

upvoted 0 times

...

Jolanda

3 months ago

I feel like left joins might be useful to include all employees, but I'm not completely confident about how it affects the results.

upvoted 0 times

...

Fanny

4 months ago

I think we practiced something similar where we had to filter out unnecessary relationships. Maybe a table restriction is the way to go?

upvoted 0 times

...

Carissa

4 months ago

I remember we discussed how inner joins can limit results, but I'm not sure if that's the best option here.

upvoted 0 times

...

Clare

4 months ago

This looks straightforward to me. I'll just change the Job Relationship join to an inner join to filter out the extra rows and get the matrix manager data I need.

upvoted 0 times

...

German

4 months ago

The key here is to focus on getting the matrix manager data, while avoiding the extra HR and second manager rows. I'll start with a left join and see if that solves the problem.

upvoted 0 times

...

Cathrine

4 months ago

I'm a bit confused by the multiple rows per employee issue. I wonder if I need to do some kind of aggregation or grouping to get just one row per employee.

upvoted 0 times

...

Hailey

5 months ago

Okay, I think I've got this. I'll try changing the Job Relationship join to a left join to make sure I capture all the employees, even if they don't have a matrix manager.

upvoted 0 times

...

Alida

5 months ago

Hmm, this seems like a tricky one. I'll need to think through the different join types carefully to figure out the best approach.

upvoted 0 times

...

Lashon

5 months ago

This question is making my head spin. I'm just going to close my eyes and point to an answer. Eeny, meeny, miny, moe, catch a tiger by the toe...

upvoted 0 times

...

Florinda

5 months ago

I'm not sure, but I think B) Change the Job Relationship to include a table restriction could also work.

upvoted 0 times

...

Leslee

5 months ago

I disagree, I believe the correct answer is D) Change the Job Relationship join to a left join.

upvoted 0 times

...

Muriel

7 months ago

Hold up, what's a 'matrix manager' anyway? Is that like a manager who can bend reality or something? I'm going with option B just to be safe.

upvoted 0 times

...

Nakita

7 months ago

I think the answer is A) Change the Job Relationship join to an inner join.

upvoted 0 times

...

Jesusa

7 months ago

Option C seems like the way to go. A right join will give you the matrix manager information, and it's more intuitive than a left join.

upvoted 0 times

...

Stephen

7 months ago

I think option D is the correct answer. Using a left join will ensure that all employees are included, even if they don't have a matrix manager assigned.

upvoted 0 times