Study with C2090-421 Actual Test Questions

Walking into the testing center unprepared is a gamble. The Actualtests4sure desktop test engine recreates the look, timing, and pressure of the IBM C2090-421 exam, so the format feels routine long before your test date arrives.

IBM C2090-421 Exam Overview:

IBM C2090-421 Exam Syllabus Topics:

Your IBM C2090-421 Exam Questions, Answered

IBM InfoSphere DataStage v8.5 Sample Questions:

Question 1

Records in a source file must be aggregated for further processing. Which two conditions would require the use of a Transformer stage instead of or in addition to an Aggregator stage? (Choose two.)

A. The aggregation is a custom formula for your enterprise.
B. The data hasn't been sorted or grouped.
C. A global aggregation across all partitions is needed.
D. Aggregation results outside of a certain range need to be flagged as abnormal.

Question 2

A job contains a Sort stage that sorts a large volume of data across a cluster of servers. Due to new requirements, the customer has requested that this sorting be done on a subset of servers identified in the configuration file to minimize impact on database nodes. The $APT_CONFIG_FILE shows no sort disk pool for any node. Which two steps will accomplish this? (Choose two.)

A. Create a sort scratch disk pool with a subset of nodes in the parallel configuration file.
B. Define a non-default node pool with a subset of nodes in the parallel configuration file.
C. Assign a separate config file just for the Sort stage.
D. Use the environment variable $APT_SCRATCH_SPACE_SORT_USAGE.
E. Have an appropriate node constraint within the Sort stage.

Question 3

There is a requirement to load mainframe data with array columns having redefined fields into a flat file. How can the Complex Flat File

A. Within CFF, use the Complex File Load Option window with "Flatten selective arrays" option selected. Select the array with redefine column(s) and click redefine check box option.
B. Within CFF, use the Complex File Load Option window with "Flatten all arrays" option selected. CFF will handle flattening automatically.
C. CFF does not support flattening for redefined fields.
D. Select the Records ID tab on the Stage page. Select a record from the Records list. Select the column(s) with the redefine from the Column list. Within CFF, use the Complex File Load Option window with "Flatten selective arrays" option selected.

Question 4

Your customer is using Source Code Control Integration for Information server and have tagged artifacts for version 1. You must create a deployment package from the version 1.
Before you create the package you will have to ensure the project is up to date with version 1.
What two things must you do to update the meta-data repository with the artifacts tagged as version 1? (Select two)

A. Right-click the asset and click the Deploy command.
B. Right-click the asset and click the Team command to update the Source Control Workspace with the asset.
C. Right-click the asset and click Replace From Source Control Workspace.
D. Right-click the asset and click the Team Import command.

Question 5

Which two tasks can the Slowly Changing Dimensions (SCD) stage perform? (Choose two.)

A. Look up whether a record with a matching business key value exists in a dimension table. If it does, add new values for selected fields to values lists for those fields.
B. Look up whether a record with a matching business key value exists in a fact table. If it does not, retrieve a new surrogate key value and insert a new row into the fact table.
C. Look up whether a record with a matching business key value exists in a dimension table. If it does not, retrieve a new surrogate key value and insert a new row into the dimension table.
D. Look up whether a record with a matching business key value exists in a dimension table. If it does, mark the record as not-current, and generate a new record with new values for selected fields.

Solutions: