nerdexam
SAP

C_HANAIMP_12 · Question #62

What performance technique should you implement to improve join performance? Please choose the correct answer. Response:

The correct answer is B. Join on key fields between tables in a dimension view. See the full explanation below for the reasoning.

Question

What performance technique should you implement to improve join performance? Please choose the correct answer. Response:

Options

  • AUse joins instead of unions for combining large data sets.
  • BJoin on key fields between tables in a dimension view.
  • CDo NOT use dynamic joins if you require optimal performance.
  • DAlways use referential joins in star join views.

How the community answered

(32 responses)
  • A
    3% (1)
  • B
    75% (24)
  • C
    6% (2)
  • D
    16% (5)

Community Discussion

No community discussion yet for this question.

Full C_HANAIMP_12 Practice