nerdexam
SAP

C_HANAIMP141 · Question #19

You have been asked to create an SAP HANA attribute view using the tables Employee (lefttable.and Department (righttable.shown in the attached diagram. Your view should contain the columns NAME and…

The correct answer is D. Left outer join. See the full explanation below for the reasoning.

Question

You have been asked to create an SAP HANA attribute view using the tables Employee (lefttable.and Department (righttable.shown in the attached diagram. Your view should contain the columns NAME and D_Name for all employees. Which of the following join types do you use?

Options

  • AText join
  • BInner join
  • CReferential join
  • DLeft outer join

How the community answered

(48 responses)
  • A
    2% (1)
  • B
    6% (3)
  • C
    15% (7)
  • D
    77% (37)

Community Discussion

No community discussion yet for this question.

Full C_HANAIMP141 Practice