Latest IBM C2090-421 Actual Free Exam Questions & Community Discussion, Page 2

Question #16

What are two advantages of using Runtime Column Propagation (RCP)? (Choose two.)

A. RCP is not a feature of DataStage.

B. Columns not specifically used in the flow are propagated as if they were.

C. Sequential files don't require schema files when using RCP.

D. Only columns used in the data flow need to be defined.

E. Only columns that are defined as VarChar need RCP enabled.

Discussion 0

Correct Answer: B,D Vote an answer

Question #17

How does the Complex Flat File stage (CFF) support the use of "OCCURS DEPENDING ON" clause?

A. The related elements are output as arrays.

B. The related elements are output as denormalized fields.

C. The related elements are output as subrecords.

D. CFF does not support this clause.

Discussion 0

Correct Answer: A Vote an answer

Question #18

You would like to run a particular processing job within a job sequence for each weekday of the week. How could you do this? (Select two)

A. Set the frequency property in the job scheduler to weekdays only.

B. Call a routine in the job sequencer that starts the processing job for each day you would like to process.

C. Have a parameter set that contains the days of the week you would like to process and routine to parse the days of the week contained in the "day" parameter.

D. Start Loop and End Loop activity stages on the job sequencer canvas where you loop through the days and pass a value for each day into the job via parameter.

Discussion 0

Correct Answer: A,D Vote an answer

Question #19

When using Runtime Column Propagation, which three stages require a schema file? (Select three)

A. Peek stage

B. DB2 Enterprise stage

C. Column Import stage

D. Sequential File stage

E. File Set stage

Discussion 0

Correct Answer: C,D,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #20

You are working on a project that contains a large number of jobs contained in many folders. You would like to review the jobs created by the former developer of the project. How can you find these jobs?

A. Sort the jobs by date in the Repository window.

B. While selecting the top folder in the project, choose Find Dependencies.

C. Use the Advanced Find feature contained in the Designer interface.

D. Filter jobs in Director Client's Repository window.

Discussion 0

Correct Answer: C Vote an answer

Question #21

Your job sequence must be restartable. It runs Job1, Job2, and Job3 serially. It has been compiled with "Add checkpoints so sequence is restartable". Job1 must execute every run even after a failure. Which two properties must be selected to ensure that Job1 is run each time, even after a failure? (Choose two.)

A. Set the Job1 Activity stage to "Do not checkpoint run.".

B. In the Job1 Activity stage set the Execution action to "Reset if required, then run.".

C. Use the Nested Condition Activity with a trigger leading to Job1; set the trigger expression type to "Unconditional".

D. Set trigger on the Job1 Activity stage to "Unconditional".

Discussion 0

Correct Answer: A,B Vote an answer

Question #22

Which three statements are true about stage variables? (Select three)

A. A derivation for a stage variable can reference stage variables that are later in the execution order.

B. Stage variables cannot contain NULL values.

C. Stage variables retain their values between rows in the stage.

D. Stage variables are executed before loop variables.

E. Stage variables are executed after constraints but before derivations.

Discussion 0

Correct Answer: A,B,C Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #23

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

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

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

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

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

Discussion 0

Correct Answer: B,C Vote an answer

Question #24

Which Oracle data type conversion is correct?

A. Oracle data type NUMBER converts to DECIMAL(38, 0) in Oracle Enterprise stage.

B. Oracle data type RAW converts to RAW in Oracle Enterprise stage.

C. Oracle data type NUMBER(15, 0) converts to INT32 in Oracle Enterprise stage.

D. Oracle data type NUMBER(6, 0) converts to INT32 in Oracle Enterprise.

Discussion 0

Correct Answer: A Vote an answer

Question #25

Which Oracle Enterprise stage read property can be set using -dboptions to tune job performance?

A. transactsize

B. partitionsize

C. arraysize

D. memsize

Discussion 0

Correct Answer: C Vote an answer

Question #26

Records in a source file must be copied to multiple output streams for further processing. Which two conditions would require the use of a Transformer stage instead of a Copy stage? (Choose two.)

A. Converting some input columns from integers to strings.

B. Concatenating data from multiple input columns.

C. Renaming one or more output columns.

D. Directing selected output records down one output link rather than another.

Discussion 0

Correct Answer: B,D Vote an answer

Question #27

Click the exhibit button.

You submit a job from DataStage Director and then log onto your DataStage Linux server to issue the command "ps -ef | grep ds" and receive the following screen: Which process is a player?

A. 7117

B. 7216

C. 7217

D. 7215

Discussion 0

Correct Answer: C Vote an answer

Question #28

Where are project level message handlers defined?

A. Director Client

B. DSENV

C. Administrator Client

D. Designer Client

Discussion 0

Correct Answer: C Vote an answer

Question #29

You set environment variable $APT_ORACLE_LOAD_OPTIONS=PTIONS(DIRECT=TRUE, PARALLEL=TRUE)?for loading index organized tables.You set environment variable $APT_ORACLE_LOAD_OPTIONS=?PTIONS(DIRECT=TRUE, PARALLEL=TRUE)?for loading index organized tables. Which statement is accurate regarding the resulting effect of this environment variable setting?

A. The Oracle database stage will run in parallel using conventional path mode.

B. The Oracle load will run in parallel using simple direct path mode.

C. Oracle load will run in parallel and bypass DataStage Director.

D. Oracle load will fail when executed.

Discussion 0

Correct Answer: D Vote an answer

Question #30

You are responsible for the projects Source Code Repository. When a developer notifies you that changes are ready to deploy you must first check them in. You will use the Information Server Source Code integration features to check in the changed assets. How will you identify the DataStage assets the developer modified in order to send them to the workspace?

A. From the workspace perspective select the project Right-click then Refresh from repository, specify a modification date and the developer's username in the Modified by fields.

B. Use Designer client Advanced Find, specify a modification date and the developer's username in the Modified by fields.

C. From Information Server Manager use Search with advanced options, specify a date modified and the developer's user name in the Modified by fields.

D. From the Information Server Manager Select the project then right-click on Synchronize with source code control system.

Discussion 0

Correct Answer: C Vote an answer

IBM C2090-421 Actual Free Exam Questions & Community Discussion

Download Free IBM C2090-421 Demo