nerdexam
IBM

000-349 · Question #27

What additional parameter is needed when using a database for an input, that is not used when using a database for output?

The correct answer is A. Query. When using a database as an input source, a Query parameter is required to specify which records to retrieve - a parameter not needed when writing to a database output.

Configuration

Question

What additional parameter is needed when using a database for an input, that is not used when using a database for output?

Options

  • AQuery
  • BPassword
  • Cmdq file name
  • DDatabase Name

How the community answered

(52 responses)
  • A
    81% (42)
  • B
    6% (3)
  • C
    2% (1)
  • D
    12% (6)

Why each option

When using a database as an input source, a Query parameter is required to specify which records to retrieve - a parameter not needed when writing to a database output.

AQueryCorrect

A database input requires a Query parameter (typically referencing an MDQ file or SQL statement) to instruct the map on which rows and columns to read from the database. A database output only needs connection and target table information because it is writing data rather than selectively retrieving it. This asymmetry reflects the fundamental difference between read and write operations against a database.

BPassword

A password is a connection credential required for both input and output database configurations, not exclusive to input.

Cmdq file name

The MDQ file name is associated with defining the query structure, but the core additional parameter concept is the query itself, not the file name specifically.

DDatabase Name

The database name is required for both input and output connections and is therefore not unique to the input use case.

Concept tested: Database input vs. output parameter differences in map editor

Source: https://www.ibm.com/docs/en/b2b-integrator/6.1?topic=cards-database-input-card-properties

Topics

#database input#query parameter#input card#adapter

Community Discussion

No community discussion yet for this question.

Full 000-349 Practice