IBM A2090-303 Actual Free Exam Questions & Community Discussion

Exam Code/Number: A2090-303
Exam Name/Title: Assessment: IBM InfoSphere DataStage v9.1 Assessment
Certification Provider: IBM
Corresponding Certification: IBM Certified Solution Developer

Exam Questions: 134
Updated On: Jun 03, 2026

Question #41

In your job you are using a Sequential File stage as a source. You have decided to use a schema file as an alternative way of specifying column definitions and record format properties. What two items are true in configuring this stage in your parallel job? (Choose two.)

A. Configure the column tab with one column named 'Input'.

B. Enable Run Time Schema propagation.

C. Configure the Schema File property with the path of the schema file definition.

D. Enable Run Time Column propagation.

E. Configure the APT_SEQFILE_HASSCHEMA property with the schema file path.

Discussion 0

Correct Answer: C,D Vote an answer

Question #42

The Score is divided into which two sections? (Choose two.)

A. File sets

B. Stages

C. Data sets

D. Schemas

E. Operators

Discussion 0

Correct Answer: C,E Vote an answer

Question #43

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? (Choose two.)

A. Right-click the asset and click Replace From Source Control Workspace.

B. Right-click the asset and click Update From Source Control Workspace.

C. Right-click the asset and click the Deploy command.

D. Right-click the asset and click the Team Import command.

E. Right-click the asset and click the Team command to update the Source Control Workspace with the asset.

Discussion 0

Correct Answer: A,E Vote an answer

Question #44

Each row contains the CustID, ProductID, ProductType and TotalAmount columns. You want to retain the record with the largest value in the TotalAmount column for each CustID and ProductType using a RemoveDuplicates stage. How can this be accomplished?

A. Hash-partition on TotalAmount. Sort on CustID, ProductType and TotalAmount.

B. Hash-partition on CustID, ProductType and TotalAmount. Sort on CustID, ProductType and TotalAmount.

C. Hash-partition on CustID. Sort on CustID, ProductType and TotalAmount.

D. Hash-partition on ProductType. Sort on ProductType, CustID and TotalAmount.

Discussion 0

Correct Answer: C Vote an answer

Question #45

Which requirement must be met to read from a database in parallel using the ODBC connector?

A. Set the Enable partitioning property to Yes.

B. Configure environment variable $APT_PARTITION_COUNT.

C. ODBC connector always reads in parallel.

D. Configure environment variable $APT_MAX_TRANSPORT_BLOCK_SIZE.

Discussion 0

Correct Answer: A Vote an answer

Question #46

Which two statements are true about Data Sets? (Choose two.)

A. Data Sets preserve partitioning.

B. Data sets contain ASCII data.

C. Data Sets represent persistent data.

D. Data Sets require repartitioning.

E. Data Sets require import/export conversions.

Discussion 0

Correct Answer: A,C Vote an answer

Question #47

Which DB2 to InfoSphere DataStage data type conversion is correct when reading data with the DB2 Connector stage?

A. VARCHAR, 32768 to SQL_VARCHAR

B. CHAR FOR BIT DATA to SQL_VARBINARY

C. XML to SQL_WVARCHAR

D. BIGINT to SQL_BIGINT (INT32)

Discussion 0

Correct Answer: C Vote an answer

Question #48

In the exhibit, a Funnel stage has two input links. Input 1 (Seq_File) comes from a Sequential File stage with "Readers per Node" set to "2". Input 2 (Dataset) comes from a dataset created with 3 partitions. In the Funnel stage, the funnel type is set to "Sequence".

The parallel configuration file contains 4 nodes. How many instances of the Funnel stage run in parallel?

A. 6

B. 2

C. 4

D. 1

Discussion 0

Correct Answer: C Vote an answer

Question #49

What is the purpose of the APT_DUMP_SCORE environment variable?

A. There is no such environment variable.

B. It is an environment variable that turns on the job monitor.

C. It is an environment variable that enables the collection of runtime performance statistics.

D. It is a reporting environment variable that adds additional runtime information in the job log.

Discussion 0

Correct Answer: D Vote an answer

Question #50

Which two statements about the Additional Connections Options property in the Teradata Connector stage to specify details about the number of connections to Teradata are true? (Choose two.)

A. Requestedsessions is a number between 1 and the number of vprocs in the operating system.

B. Total requested sessions equals sessions per player multiplied by number of nodes multiplied by players per node. The default value is 4.

C. The default for requestedsessions is the maximum number of available sessions.

D. The default for requestedsessions is the minimum number of available sessions.

E. Sessionsperplayer determines the number of connections each player in the job has to Teradata.

Discussion 0

Correct Answer: C,E Vote an answer

Download Free IBM A2090-303 Demo

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