IBM C2090-424 Exam Questions

Question 6 of 64

The Lookup stage is one of three stages that join records based on the values of key columns. What are the other stages? (Choose two.)

Join

Merge

Modify

Funnel

Difference

Correct Answer: A, B

The Lookup stage is indeed used to join records based on key column values. The other stages that perform similar joining operations are the Join stage and the Merge stage. The Join stage combines records from two input links by performing a relational join. The Merge stage combines records from multiple input links based on key columns and produces a merged output. Therefore, the correct options are Join and Merge.

Question 7 of 64

Which type of data can be extracted using the Unstructured Data stage?

XML data

Microsoft Word data

Microsoft Excel data

BigInsights HDFS file data

Correct Answer: C

Question 8 of 64

Consider a customer with multiple environments, Development, Test and Production. Which statement is TRUE?

Each environment must have a C++ compiler.

QualityStage rule sets are not a type of deployable asset.

It is not possible to revert to a previous version of a package.

A package can contain an improved version of a job which will replace the old one.

Correct Answer: D

A package can contain an improved version of a job which will replace the old one. This is useful for maintaining and updating software in multiple environments like Development, Test, and Production by allowing the deployment of new versions with enhanced features or fixes.

Question 9 of 64

Which of the following is TRUE when using a data set created with a 4 node config file?

Data sets are operating system files

Data is stored in a non-persistent form

The data set control file holds all your data

A Data Set stage can have 1 input link and multiple output links

Correct Answer: A

Data sets in a 4 node config file are generally operating system files. They are created and managed by the underlying operating system, making this the true statement out of the provided options.

Question 10 of 64

Which statement about restartable sequence jobs is TRUE?

If a restartable sequence aborts, it can be restarted from Director.

Choosing "Reset job" from Director will start the job where it left off.

Checkpoints are always added to every eligible Job Activity stage in the sequence.

There is no way to force a Job Activity stage to return if the sequence got beyond it.

Correct Answer: A