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

SAP Exam C_THR92_2505 Topic 7 Question 3 Discussion

Actual exam question for SAP's C_THR92_2505 exam
Question #: 3
Topic #: 7
[All C_THR92_2505 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

Contribute your Thoughts:

Nakita
8 hours ago
I think the answer is A) Change the Job Relationship join to an inner join.
upvoted 0 times
...
Jesusa
1 days 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
6 days 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
Joanne
3 days ago
I think option D is the correct answer.
upvoted 0 times
...
...

Save Cancel