000-421 by IBM Actual Free Exam Q&As

Question 1

How must the input data set be organized for input into the join stage? (Choose two.)

A. Unsorted B. Sorted in ascending order C. Key partitioned D. Entire partitioned E. Hash partitioned

Discussion 0

Correct Answer: B,C Vote an answer

Question 2

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. Use job run operational meta-data reports from IS Manager. C. Show Performance Statistics in the Designer. D. $APT_PM_PLAYER_STATS

Discussion 0

Correct Answer: A,C Vote an answer

Question 3

What are the three aggregation types can be set in the Aggregator stage? (Select three)

A. Calculate B. Sum Rows C. Count Values D. Count Rows E. Recalculate

Discussion 0

Correct Answer: A,D,E Vote an answer

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

Question 4

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.

Discussion 0

Correct Answer: C Vote an answer

Question 5

Click on the Exhibit button.

Which environment variable would provide this information?

A. APT_SHOW_COMPONENT_CALLS B. APT_DEBUG_PARTITION C. APT_PM_PLAYER_TIMING D. APT_STATUS

Discussion 0

Correct Answer: C Vote an answer

Question 6

The derivation for a stage variable is: Upcase(input_column1) : ' ' : Upcase(input_column2). Suppose that input_column1 contains a NULL value. Which behavior is expected?

A. NULL is written to the target stage variable. B. The job aborts. C. The target stage variable is populated with spaces or zeros depending on the stage variable data type. D. The input row is either dropped or rejected depending on whether the Transformer has a reject link.

Discussion 0

Correct Answer: A Vote an answer

Question 7

There is a requirement to transfer a large file using an FTP Enterprise stage. How can you minimize processing time when a transfer failure occurs?

A. Manually split the file into multiple files and specify restartable mode on a transfer. B. Use a sequencer to check transfer status and restart the job from the beginning on failure. C. Specify restartable mode on a transfer of the single file. D. Create multiple readers to transfer file data and specify restartable mode on Input link tab.

Discussion 0

Correct Answer: A Vote an answer

Question 8

When you run a parallel job, any error messages and warnings are written to the job log and can be viewed from the Director client. What two levels of message handlers are there? (Choose two.)

A. record level B. stage level C. project level D. job level

Discussion 0

Correct Answer: C,D Vote an answer

Question 9

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

A. istool B. Information Server Manager C. Designer Client Export D. $APT_COPY_TRANSFORMER E. dscc.exe

Discussion 0

Correct Answer: B,E Vote an answer

Question 10

What conditions are necessary for a master record and an update record to merge?

A. all of the columns in the input record match the columns in the update record B. none of the columns in the input record match the columns in the update record C. both records have the same values for the merge key column(s) that you specify D. some of the columns in the input record match the columns in the update record

Discussion 0

Correct Answer: C Vote an answer

Question 11

In the job fragment shown in the exhibit, the data going into the target Sequential File stage needs to be sorted by postal code. The Sort stage accomplishes this by running in Sequential mode and sorting by postal code. You have been asked to improve the performance of the job with a 4-node configuration file.

Which two changes will improve the performance of the job? (Choose two.)

A. Move the Sort stage in front of the Filter stage, so that the sort is performed earlier in the job. B. Add a second Sort stage just before the existing Sort stage; run the new stage in parallel mode sorting by postal code. C. Eliminate the existing Sort stage; define an in-stage sort in the Filter stage, sorting by postal code. In the target Sequential File stage choose the SortMerge collector. D. Change the mode of the existing Sort stage to parallel mode; continue to sort by postal code. In the target Sequential File stage choose the SortMerge collector.

Discussion 0

Correct Answer: C,D Vote an answer

Question 12

Which two statements are true about the usage of scratch disk? (Choose two.)

A. You can define multiple scratch disk spaces to distribute disk I/O. B. The parallel framework uses the disk space specified in the scratch disk setting to buffer virtual data set records. C. The Sort stage always uses the scratch disk. D. If "buffer" scratch disk pool is defined, the framework uses this disk pool and the default disk pool.

Discussion 0

Correct Answer: A,B Vote an answer

IBM InfoSphere DataStage v8.5 - 000-421 Exam Practice Test