Free IBM A2090-421 Practice Test & Real Exam Questions

Exam Code/Number: A2090-421
Exam Name/Title: Assessment: InfoSphere DataStage v8.5
Certification Provider: IBM
Corresponding Certification: IBM Specialist

Exam Questions: 194
Updated On: Oct 12, 2026

Question #1

Which of the following describes a type two update in a Slowly Changing Dimensions (SCD) stage?

A. An update that replaces the existing column value if a specified condition is satisfied.

B. An update the retains the existing column value in an historical row and creates a new row with the new value.

C. An update that overwrites the existing column value.

D. An update that retains the existing column value in a list and adds the new value to the list.

Discussion 0

Correct Answer: D Vote an answer

Question #2

You are about to begin major changes to jobs in a project. You want to conveniently identify job changes on an ad hoc basis. What two tasks will allow you to identify changes to your jobs? (Choose two.)

A. Select the job, then right click Compare within.

B. Select the job, then right click Cross Project Compare.

C. Import the original job from a .dsx export.

D. Before making a change to a job make a copy of the job in a different category folder.

Discussion 0

Correct Answer: A,D Vote an answer

Question #3

What are two fundamental functions of the Information Server Source Code Integration based on the Eclipse Team framework? (Choose two.)

A. Rollback Changes

B. Send to Source Code Control Workspace

C. Commit Changes

D. Replace from Source Code Control Workspace

Discussion 0

Correct Answer: B,D Vote an answer

Question #4

What stage allows for more than one reject link?

A. Lookup stage

B. Peek stage

C. Merge stage

D. Join stage

E. Funnel stage

Discussion 0

Correct Answer: C Vote an answer

Question #5

A customer requests you to configure a Sequential File stage in a clustered environment. The stage must read a varying number of files each run in a single pass and append the name of the file the row was read from when an error occurs. What three steps are required to achieve this? (Select three)

A. Specify a file pattern option along with a file name mask that captures entire file list.

B. Specify File Name Column property.

C. Set environment variable $APT_SEQ_FILE_INCL_FILENAMES.

D. Set environment variable $APT_IMPORT_PATTERN_USES_FILESET.

E. Specify multiple "File" properties.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question #6

What are the three features of Information Server that allow you to deploy DataStage objects? (Select three)

A. $APT_COPY_TRANSFORMER

B. istool

C. Information Server Manager

D. Designer Client Export

E. dscc.exe

Discussion 0

Correct Answer: C,E Vote an answer

Question #7

In which two situations is it appropriate to use a Sparse Lookup? (Choose two.)

A. When accessing DB2 data using the DB2 API stage.

B. When the output of the Lookup stage needs to be hashed partitioned.

C. When invoking a stored procedure within a database per row in the streaming link.

D. When reference data is significantly larger than the streaming data (100:1).

Discussion 0

Correct Answer: C,D Vote an answer

Question #8

A customer is complaining of poor performance from the job shown in the exhibit, which aggregates and joins on ZIP code. Currently all partitioning is set to "Auto" and sort/partition insertion is allowed.

What would give the best performance improvement for the job?

A. Use same partitioning on all input links in the job; create the input data set by hash-partitioning its input on ZIP code.

B. Hash partition and sort on ZIP code prior to the Copy stage, and use same partitioning on the Aggregator and Join stages.

C. Hash partition and sort on ZIP code on the input links to the Aggregator and Join stages.

D. Hash partition and sort on ZIP code prior to the Copy stage and use entire partitioning on the output of the Aggregator stage.

Discussion 0

Correct Answer: B Vote an answer

Question #9

An important top level Job Sequence has been modified. It controls a process flow consisting of sub Job Sequences, Routines and Parallel Jobs. You must set up a new project to test the top level Job Sequence. You are not allowed to move any repository objects that are not impacted by the top level Job Sequence.
What two options would identify only the repository objects impacted by the change made to the top level Job Sequence? (Select two)

A. Select the top Level Job Sequence and Dependency of (deep).

B. Repository Advanced Find Where Used

C. On Export check Include dependencies of

D. Click Impact Analysis Icon on Designer Client Toolbar.

Discussion 0

Correct Answer: B,C Vote an answer

Question #10

Which two statements are correct when referring to an Aggregator Stage? (Choose two.)

A. Use Sort method with a large number of distinct key-column values

B. Use Sort method for a limited number of distinct key values

C. Use Hash method with a large number of distinct key-column values

D. Use Hash method for a limited number of distinct key values

Discussion 0

Correct Answer: A,D Vote an answer

Question #11

You have a 3TB dataset hash-partitioned on CustID in a clustered environment. You need to join this dataset with 1GB of reference data on OrderID. Which technique is most appropriate?

A. Use Lookup stage, select auto partitioning for the stream link and entire partitioning for the reference link.

B. Use Join stage, hash-partition and sort both link on OrderID.

C. Use Lookup stage, select auto partitioning for the stream link and hash-partition the reference link on CustI

D. Use Lookup stage, select auto partitioning for both link.

Discussion 0

Correct Answer: A Vote an answer

Question #12

Click the Exhibit button.

The job in the exhibit runs to successful completion with no warnings. However, a validation test identifies that the CUSTOMER_MASTER table is empty. You suspect the cause to be related to the NEW_CUSTOMERS table or a defect in the job. Examining runtime meta-data will help you track down the problem. Which two product features will help you isolate the cause of the problem? (Choose two.)

A. Job Monitor Tool in the Director Client

B. Show Performance Statistics in the Designer.

C. $APT_PM_PLAYER_STATS

D. Use job run operational meta-data reports from IS Manager.

Discussion 0

Correct Answer: A,B Vote an answer

Question #13

You are connected to a domain and must configure it for Source Code Integration.
What are the two things that must be done to associate your DataStage repository with a source control system? (Select two)

A. From Designer Client choose Team Share Project.

B. Create a source code control project with the same name as the domain. Choose Integrate Source Control.

C. From Information Server Manager choose Team Share Project.

D. From Information Server Manager choose Team Import.

Discussion 0

Correct Answer: B,D Vote an answer

Download Free IBM A2090-421 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM A2090-421 exam.