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

9 months ago

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

upvoted 0 times

...

Noemi

9 months ago

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

upvoted 0 times

...

Helga

10 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

10 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

10 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

9 months ago

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

upvoted 0 times

...

Ethan

9 months ago

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

upvoted 0 times

...

Johnna

9 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

10 months ago

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

upvoted 0 times

...

Valentine

10 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

9 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

10 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

10 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

9 months ago

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

upvoted 0 times

...

Sabine

9 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

9 months ago

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

upvoted 0 times

...

Alex

9 months ago

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

upvoted 0 times

...

Keneth

10 months ago

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

upvoted 0 times

...

Huey

10 months ago

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

upvoted 0 times

...

Yasuko

11 months ago

I thought Runtime and People Scope.

upvoted 0 times

...

Kathrine

11 months ago

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

upvoted 0 times

...

Yasuko

11 months ago

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

upvoted 0 times

...

Francine

11 months ago

Which one?

upvoted 0 times

...

Yasuko

11 months ago

Got a tricky question in the exam.

upvoted 0 times

...

Merlyn

12 months ago

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

upvoted 0 times

...

Kirk

12 months ago

What about Filter Groups and Dynamic?

upvoted 0 times

...

Merlyn

12 months ago

Yes, they can include Runtime and People Scope.

upvoted 0 times

...

Kirk

12 months ago

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

upvoted 0 times

...