nerdexam
IBM

C2090-304 · Question #34

Refer to the exhibit that appears below. You are developing an ISD reference match job. The reference data is maintained in a database and must be referenced at runtime. You have three passes in…

The correct answer is C. You can select reference data from the database using user defined SQL. See the full explanation below for the reasoning.

Question

Refer to the exhibit that appears below. You are developing an ISD reference match job. The reference data is maintained in a database and must be referenced at runtime. You have three passes in your match specification and the input is one record at a time. Which statement is true about the job design?

Exhibit

C2090-304 question #34 exhibit

Options

  • AUse normal lookup in the lookup stage.
  • BThe Lookup stage should be replaced with Join stage.
  • CYou can select reference data from the database using user defined SQL.
  • DYou need to add two more Lookup stages to select necessary reference data.

How the community answered

(35 responses)
  • A
    17% (6)
  • B
    3% (1)
  • C
    71% (25)
  • D
    9% (3)

Community Discussion

No community discussion yet for this question.

Full C2090-304 Practice