Exam C2090-424 All QuestionsBrowse all questions from this exam
Go to Exam
Question 24

Your job consists of a DB2 Connector stage followed by a Sort stage followed by a Transformer stage followed by another DB2 Connector stage.

The following two Balanced Optimizer options have been selected:

✑ Push processing to data sources

✑ Push processing to data targets

The following two Balanced Optimizer options have NOT been selected:

✑ Push data reduction processing to data targets

✑ Push all processing into the (target) data server

Assuming the job design allows for maximum optimization, what does the optimized job design look like?

    Correct Answer: B

    When processing involves database connectors and the Balanced Optimizer options 'Push processing to data sources' and 'Push processing to data targets' are selected, the goal is to minimize intermediate processing stages that are not essential for data movement or transformation. Therefore, with the given job setup and the indication to push processing to the endpoints, the most optimized design would involve having just the DB2 Connector stages, thus making the job design have a DB2 Connector stage followed by another DB2 Connector stage.

Discussion
MOMOABELOption: B

Correct Answer is B