Limited Time Discount Offer 30% Off - Ends in 02:00:00


IBM C2090-303 Exam - IBM InfoSphere DataStage v9.1

Questions & Answers for IBM C2090-303

Showing 1-15 of 132 Questions

Question #1 - Topic 1

You are asked by your customer to collect partition level runtime metadata for DataStage
parallel jobs. You must collect this data after each job completes. What two options allow
you to automatically save row counts and CPU time for each instance of an operator?
(Choose two.)



C. Enable the job property "Record job performance data".

D. Open up the job in Metadata Workbench and select the "Data Lineage"option.

E. Click the Performance Analysis icon in the toolbar to open the Performance Analyzer utility.

Question #2 - Topic 1

On the DataStage development server, you have been making enhancements to a copy of
a DataStage job running on the production server. You have been asked to document the
changes you have made to the job. What tool in DataStage Designer would you use?

A. Compare Against

B. diffapicmdline.exe

C. DSMakeJobReport

D. Cross Project Compare

Question #3 - Topic 1

Which option is required to identify a particular job player processes?Which option is
required to identify a particularjob? player processes?

A. Set $APT_DUMP_SCORE to true.

B. Set $APT_PM_SHOW_PIDS to true.

C. Log onto the server and issue the command "ps -ef | grep ds".

D. Use the DataStage Director Job administration screen to display active player processes.

Question #4 - Topic 1

Which statement describes what happens when Runtime Column Propagation is disabled
for a parallel job?

A. An input column value flows into a target column only if it matches it by name.

B. An input column value flows into a target columnonly if it is explicitly mapped to it.

C. You must set APT_AUTO_MAP project environment to true to allow output link mapping to occur.

D. An input column value flows into a target column based on its position in the input row. For example, first column in the input row goes into the first target column.

Question #5 - Topic 1

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. The default for requestedsessions is the minimum number of available sessions.

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

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

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

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

Question #6 - Topic 1

Which two actions are available when editing a message handler? (Choose two.)

A. Abort job

B. Demote to warning

C. Suppress from job log

D. Demote to informational

E. Suppressfrom the project

Question #7 - Topic 1

In your ETL application design you have found several areas of common processing
requirementsin the mapping specifications. These common logic areas found include: code
validation lookups and name formatting. The common logic areas have the same logic, but
the jobs using them would have different column metadata. Choose the action that gives
you the best reusability design to effectively implement these common logic areas in your
ETL application?

A. Create parallel routines for each of the common logic areas and for each of the unique column metadata formats.

B. Create separate jobs for each layout and choose the appropriate job to run within a job sequencer.

C. Create parallel shared containers and define columns combining all data formats.

D. Create parallel shared containers with Runtime Column Propagation (RCP) ON and define only necessary common columns needed for the logic.

Question #8 - Topic 1

Which method is used to specify when to stop a job because of too many rejected rowswith
an ODBC Connector?

A. In the Abort when field, select Max

B. In the Abort when field, select Rows

C. In the Abort when field, select Count

D. In the Abort when field, select Amount

Question #9 - Topic 1

Suppose a user ID has been created with DataStage and QualityStage component
authorization. Which client application would be used to give that user ID DataStage
Developer permission?

A. DataStage Director client

B. DataStage Designer client

C. DataStage Administrator client

D. Information Server Web Console Administrator client

Question #10 - Topic 1

Identify the two delimiter areas available to be configured in theSequential File format tab
properties? (Choose two.)

A. File delimiter

B. Null delimiter

C. Final delimiter

D. Field delimiter

E. End of group delimiter

Question #11 - Topic 1

Which step is required to change from a normal lookup to a sparse lookup in an ODBC
Connector stage?

A. Change the partitioning to hash.

B. Sort the data on the reference link.

C. Change thelookup option in the stage properties to "Sparse".

D. Replace columns at the beginning of a SELECT statement with a wildcard asterisk (*).

Question #12 - Topic 1

What are the two Transfer Protocol TransferMode property options for the FTP Enterprise
stage? (Choose two.)






Question #13 - Topic 1

In the Slowly Changing Dimension stage, a dimension columns Purpose code property can
trigger which two actions. (Choose two.)

A. Update fact table keys.

B. Detect dimension changes.

C. Update the dimension table.

D. Insert rows into the fact table.

E. Delete duplicate dimension table rows.

Question #14 - Topic 1

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. 1

B. 2

C. 4

D. 6

Question #15 - Topic 1

A 100MB input dataset has even distribution across400 unique key values. When you run
with a 4-node configuration file, which two changes could improve sort performance in this
scenario? (Choose two.)

A. Convert all numeric fields to varchars.


C. Alter the Sortstage properties to perform a stable sort.

D. Specify Round Robin partitioning on the input link to the Sort stage.

E. Specify "Restrict Memory Usage" to 60MB on the Sort stage properties.


You save

Enter Your Email Address to Receive Your 30% Discount Code


You save

Use Discount Code:

A confirmation link was sent to your e-mail.

Please check your mailbox for a message from and follow the directions.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

  • Realistic exam simulation and exam editor with preview functions
  • Whole exam in a single file with several different question types
  • Customizable exam-taking mode & detailed score reports