C2090-421 Exam Training Practice Tests (IBM InfoSphere DataStage v8.5)]

Question 1

You have a dataset hash-partitioned and sorted on CustID. You need to create a Sequential File sorted on CustID from this dataset. Which technique is the most appropriate?

A. Use SortMerge collector for the Sequential File input link. B. Insert Sort stage before the final Sequential File stage and use Ordered collector for the Sequential File stage input link. C. Use Copy stage. D. Insert Sort stage before the final Sequential File stage and use Round Robin collector for the Sequential File stage input link.

Correct Answer: A

Question 2

Which two partitioning methods require keys? (Choose two.)

A. Round Robin B. Modulus C. Hash D. Entire

Correct Answer: B,C

Question 3

In the exhibit, the Aggregator stage aggregates over CustomerID. The Join stage joins by CustomerID. When the score is created, DataStage will insert hash partitioners and tsort operators to ensure the correct results.

Which two choices will eliminate sort operators from being inserted at run-time? (Select two)

A. Add a Sort stage before the Copy stage and specify Auto partitioned for the links going into the Aggregator and Join stages. B. Add a Sort stage before the Aggregator stage and specify the Same partitioner for the link going into the Aggregator Set the $APT_SORTJNSERTION_CHECK_ONLY environment variable to "True". C. Add a Sort stage before the Copy stage and specify Same partitioners for the links going into the Aggregator and Join stages. D. Add Sort stages in front of the Join stage and specify the Same partitioner for the links going into the Join. Set the $APT_NO_SORT_INSERTION environment variable to "True".

Correct Answer: C,D

Question 4

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

A. memsize B. partitionsize C. arraysize D. transactsize

Correct Answer: C

Question 5

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

Correct Answer: B,D

Question 6

You have been asked to delete a shared container from the project by your customer. Before you do this you want to make sure it will not impact other objects in the project. How will you ensure that deleting the shared container will not cause a failure when jobs are recompiled?

A. Select the shared container, Right-click on the Where used command. B. Select the shared container, Right-click on the Where used (deep) command. C. Select the shared container, Right-click on the Dependencies (deep) command. D. Advanced find, set Dependencies Of field equal to the container name, and Check the Option to Include nested results for Dependency searches.

Correct Answer: B

Question 7

Which of the following describes what happens when Runtime Column Propagation is enabled?

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 column based on its position in a Schema file. C. An input column value flows into a target column only if it is explicitly mapped to it. 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.

Correct Answer: A

Question 8

Refer to the exhibit.

You submit a job from DataStage Director and then log onto your DataStage Linux server to issue the command "ps-ef | grepds" and receive the following screen:
Which process is the section leader for node2?

A. 7221 B. 7219 C. 7220 D. 7216

Correct Answer: A

Question 9

What Information Server tool provides integration with source code control repositories?

A. Information Services Director B. Information Server Manager C. Multiple Job Compile D. DataStage Designer

Correct Answer: B

Question 10

You would like to invoke a job sequence from a web service. How can this be done?

A. Select the job sequence when creating the web service operation, B. Create a DataStage routine that invokes the job sequence and invoke the routine from a DataStage job. Then use this job when creating the web service operation. C. Check the use job sequence checkbox when creating the web service. D. Invoke the job sequence using the dsjob command.

Correct Answer: B

Question 11

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. Enable the job property "Log report messages after each job run". C. $APT_PM_PLAYER_TIMINGS D. Enable the job property "Record job performance data".

Correct Answer: B,C

Question 12

Which condition is required to use the LastRowInGroup() function to determine a key break on a field?

A. The input data has to be sorted by the key field and DataStage must be able to detect that the data is sorted, for example, by the presence of a Sort stage. B. The LastRowInGroup() function does not require the data to be either sorted or grouped by the key field. If necessary the LastRowInGroup() function will perform a sort. C. The LastRowInGroup() function requires the data to be grouped by the key field, but the data does not have to be sorted. D. The input data has to be sorted by the key field, but it is not required that DataStage be able to detect this. For example, the input data might be sorted before it is input to the job. (However, the job will abort at runtime if the data isn't sorted.)

Correct Answer: A

Question 13

Which statement is true about buffering?

A. The "buffer" scratch disk pool needs to be defined to allow the framework to perform data buffering. B. The framework uses /tmp by default for buffering on Unix systems. C. In a clustered environment, using a disk space on an NFS mount for buffering improves performance. D. The buffer operator uses both memory and disk storage.

Correct Answer: D

Question 14

In which two situations would you use the Web Services Client stage? (Choose two.)

A. You do not need both input and output links in a single web service operation. B. You need to create a WSDL. C. You want to deploy a service. D. You need the Web service to act as either a data source or a data target during an operation.

Correct Answer: A,D

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