SAP Exam C_THR92_2411 Topic 7 Question 3 Discussion

Actual exam question for SAP's C_THR92_2411 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 a left 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 an inner join.

Show Suggested Answer

Suggested Answer: D

by Geraldine at Jan 15, 2025, 09:44 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Ozell

2 months ago

I'm not sure, but I think changing the join to a left join makes sense to return one row per employee with the matrix manager.

upvoted 0 times

...

Britt

2 months ago

I agree with Sheron, because a left join will include all rows from the first table and only matching rows from the second table.

upvoted 0 times

...

2 months ago

Hmm, I think the answer is B. Gotta love those table restrictions, they always save the day!

upvoted 0 times

Jeffrey

1 months ago

Make sure to include the necessary columns in the SELECT statement to display the employee's matrix manager.

upvoted 0 times

...

Pok

2 months ago

You can use a subquery to filter out the rows with relationships to HR managers and second managers.

upvoted 0 times

...

Lemuel

2 months ago

Use a filter to include only rows where the relationship type is 'Matrix Manager'.

upvoted 0 times

...