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

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

10 months ago

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

upvoted 0 times

...

Noemi

10 months ago

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

upvoted 0 times

...

Helga

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

11 months ago

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

upvoted 0 times

...

Aileen

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

10 months ago

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

upvoted 0 times

...

Ethan

10 months ago

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

upvoted 0 times

...

Johnna

10 months ago

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

upvoted 0 times

...

Mozell

10 months ago

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

upvoted 0 times

...

Dylan

10 months ago

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

upvoted 0 times

...

Ceola

11 months ago

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

upvoted 0 times

...

Valentine

11 months ago

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

upvoted 0 times

Janey

10 months ago

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

upvoted 0 times

...

Kanisha

10 months ago

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

upvoted 0 times

...

Huey

11 months ago

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

upvoted 0 times

...

Francine

11 months ago

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

upvoted 0 times

...

Nickie

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

10 months ago

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

upvoted 0 times

...

Sabine

10 months ago

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

upvoted 0 times

...

Niesha

10 months ago

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

upvoted 0 times

...

Alex

10 months ago

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

upvoted 0 times

...

Keneth

11 months ago

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

upvoted 0 times

...

Huey

11 months ago

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

upvoted 0 times

...

Yasuko

12 months ago

I thought Runtime and People Scope.

upvoted 0 times

...

Kathrine

12 months ago

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

upvoted 0 times

...

Yasuko

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

...