SAP Exam C_THR92_2311 Topic 1 Question 11 Discussion

Actual exam question for SAP's C_THR92_2311 exam

Question #: 11
Topic #: 1

You are creating a query that lists employee information such as name, address, and dependent information. The query uses Personal Information as the driving table and joins the Dependents and Address tables. You notice many employees are missing from the result set.

What are the reasons?

APersonal Information is joined to Dependents table with a left join and the Dependents table is joined to the Address table with a left join.

BPersonal Information is joined to both the Dependents table and the Address table with an inner join.

CPersonal Information is joined to Address table with a left join and the Address table is joined to the Dependents table with a left join.

DPersonal Information is joined to both the Dependents table and the Address table with a left join.

Show Suggested Answer

Suggested Answer: B, C

by Jacqueline at Apr 21, 2024, 11:45 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Jeanice

1 years ago

This question is a piece of cake. A) Runtime and D) Dynamic are the way to go. Though I do wonder if the exam committee has a strange sense of humor with those other options.

upvoted 0 times

Noemi

1 years ago

Yeah, the other options like B) People Scope and C) Filter Groups seem like distractions.

upvoted 0 times

...

Noemi

1 years ago

I agree, A) Runtime and D) Dynamic are the correct filter types for user-prompted queries.

upvoted 0 times

...

Helga

1 years ago

A) Runtime and D) Dynamic? Sounds about right. I wonder if the exam writers were running out of ideas for filter types. 'People Scope' - really?

upvoted 0 times

...

Tawna

1 years ago

Easy peasy! A) Runtime and D) Dynamic are the two correct answers. I could answer this in my sleep.

upvoted 0 times

...

Aileen

1 years ago

Hmm, A) Runtime and D) Dynamic seem like the obvious choices to me. Who would even consider B) People Scope or C) Filter Groups? Clearly the wrong answers.

upvoted 0 times

Jerry

1 years ago

Definitely, A) Runtime and D) Dynamic are the most relevant options for user-prompted filters.

upvoted 0 times

...

Ethan

1 years ago

I agree, B) People Scope and C) Filter Groups don't seem to fit the criteria.

upvoted 0 times

...

Johnna

1 years ago

Definitely, A) Runtime and D) Dynamic are the user-prompted filter types in a live data query.

upvoted 0 times

...

Mozell

1 years ago

I agree, B) People Scope and C) Filter Groups don't seem relevant in this context.

upvoted 0 times

...

Dylan

1 years ago

I think A) Runtime and D) Dynamic are the correct options.

upvoted 0 times

...

Ceola

1 years ago

I think A) Runtime and D) Dynamic are the correct filter types for live data queries.

upvoted 0 times

...

Valentine

1 years ago

A) Runtime and D) Dynamic, definitely. I can't imagine any other answer choices being valid for this question.

upvoted 0 times

Janey

1 years ago

A) Runtime and D) Dynamic are the correct answers for user-prompted filter types in a live data query.

upvoted 0 times

...

Kanisha

1 years ago

B) People Scope and C) Filter Groups are also user-prompted filter types in a live data query.

upvoted 0 times

...

Huey

1 years ago

A) Runtime and D) Dynamic, definitely. I can't imagine any other answer choices being valid for this question.

upvoted 0 times

...

Francine

1 years ago

No, People Scope is not user-prompted. It has to be Dynamic.

upvoted 0 times

...

Nickie

1 years ago

I think the correct answers are A) Runtime and D) Dynamic. Those seem to be the user-prompted filter types in a live data query.

upvoted 0 times

Carmela

1 years ago

Yes, those are the two correct answers for user-prompted filter types in a live data query.

upvoted 0 times

...

Sabine

1 years ago

I agree, A) Runtime and D) Dynamic are the correct user-prompted filter types in a live data query.

upvoted 0 times

...

Niesha

1 years ago

Yes, those are the two correct answers for user-prompted filter types in a live data query.

upvoted 0 times

...

Alex

1 years ago

I agree, A) Runtime and D) Dynamic are the correct user-prompted filter types.

upvoted 0 times

...

Keneth

1 years ago

Yes, those are the two correct answers for user-prompted filter types in a live data query.

upvoted 0 times

...

Huey

1 years ago

I agree, A) Runtime and D) Dynamic are the correct user-prompted filter types.

upvoted 0 times

...

Yasuko

1 years ago

I thought Runtime and People Scope.

upvoted 0 times

...

Kathrine

1 years ago

Oh, I remember that. The correct answers are Runtime and Dynamic.

upvoted 0 times

...

Yasuko

1 years ago

About user-prompted filter types in a live data query.

upvoted 0 times

...

Francine

1 years ago

Which one?

upvoted 0 times

...

Yasuko

1 years ago

Got a tricky question in the exam.

upvoted 0 times

...

Merlyn

1 years ago

Those are not user-prompted filter types in this context.

upvoted 0 times

...

Kirk

1 years ago

What about Filter Groups and Dynamic?

upvoted 0 times

...

Merlyn

1 years ago

Yes, they can include Runtime and People Scope.

upvoted 0 times

...

Kirk

1 years ago

Are user-prompted filter types in a live data query?

upvoted 0 times

...