nerdexam
IBM

C2090-303 · Question #24

Which step is required to change from a normal lookup to a sparse lookup in an ODBC Connector stage?

The correct answer is C. Change the lookup option in the stage properties to "Sparse". See the full explanation below for the reasoning.

Question

Which step is required to change from a normal lookup to a sparse lookup in an ODBC Connector stage?

Options

  • AChange the partitioning to hash.
  • BSort the data on the reference link.
  • CChange the lookup option in the stage properties to "Sparse".
  • DReplace columns at the beginning of a SELECT statement with a wildcard asterisk (*).

How the community answered

(45 responses)
  • A
    11% (5)
  • B
    7% (3)
  • C
    78% (35)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full C2090-303 Practice