nerdexam
SAP

C_HANAIMP142 · Question #238

Refer to the exhibit. You have been asked to create an SAP HANA attribute view using the tables Employee (left table) and Department (right table), shown in the attached diagram. Your view should…

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

Question

Refer to the exhibit. You have been asked to create an SAP HANA attribute view using the tables Employee (left table) and Department (right table), 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?

Exhibit

C_HANAIMP142 question #238 exhibit

Options

  • AReferential join
  • BLeft outer join
  • CText join
  • DInner join

How the community answered

(24 responses)
  • A
    4% (1)
  • B
    83% (20)
  • C
    4% (1)
  • D
    8% (2)

Community Discussion

No community discussion yet for this question.

Full C_HANAIMP142 Practice