Prep and try our A2090-421 valid and latest training questions & answers

IBM A2090-421 Exam Overview:

IBM A2090-421 Exam Syllabus Topics:

IBM Assessment: InfoSphere DataStage v8.5 Sample Questions:

Question 1

You are experiencing performance issues for a given job. You are assigned the task of understanding what is happening at run time for that job. What are the first two steps you should take to understand the job performance issues? (Choose two.)

A. Replace Transformer stages with custom operators.
B. Run job with $APT_DUMP_SCORE set to true.
C. Run job with $APT_TRACE_RUN set to true.
D. Review the objectives of the job.

Question 2

A dataset was created earlier with one partition, with the Preserve Partitioning flag set. A subsequent job using a 2-node configuration file reads from that dataset, passing data to a Transformer stage with "Same" partitioning.
Which two statements are true? (Select two)

A. DataStage will repartition the data and run one instance of the Transformer stage.
B. The DataStage job will abort.
C. Inserting a Sort stage prior to the Transformer stage will force its parallel execution.
D. Setting the Preserve Partitioning flag to "Set" will run one instance of the Transformer stage.
E. Setting the Preserve Partitioning flag to "Clear" will generate two instances of the Transformer stage.

Question 3

You are asked by your customer to collect partition level runtime meta-data 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? (Select two)

A. $APT_PERFORMANCE_DATA
B. $APT_PM_PLAYER_TIMINGS
C. Enable the job property "Log report messages after each job run".
D. Enable the job property "Record job performance data".

Question 4

A scenario requires selecting only the most recent transactions for each of 2 million unique customers, from a 20 million row DB2 source table containing order history. Which parallel job design would satisfy this functional requirement?

A. Using the DB2 API stage, select all rows. Use a Sort stage with customer number and order date sort keys in ascending order, then Remove Duplicates with Last Duplicate to retain.
B. Select all rows using the ODBC Connector stage, use a Sort Aggregator on customer number key to select the maximum order date.
C. Using the DB2 Enterprise stage, select all rows. Perform a unique Sort using customer number and order date sort keys in ascending order.
D. Using the Dynamic Relational stage, use custom SQL to select all DISTINCT customer numbers from the order history table.

Question 5

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 Information Server Manager Select the project then right-click on Synchronize with source code control system.
B. 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.
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. Use Designer client Advanced Find, specify a modification date and the developer's username in the Modified by fields.

Solutions: