IBM Websphere Datastage V.8.0 (000-418) Free Practice Test

Question 1

You have a parallel job that does not scale beyond two nodes. After investigation you find that the data has been partitioned on a DoNotCall flag, which has only "Y" or "N" values, and you have an Aggregator stage that is accumulating totals based on this flag using a sort method. Which two techniques could you use to allow the job to scale? (Choose two.)

A. Change the aggregation method to hash to eliminate the blocking sort operation.

B. Add an additional column for partitioning to result in additional data partitions.

C. Change the preserve partitioning option on the stage ahead of the aggregator to clear partitioning.

D. Change the partitioning method to Round Robin; add a second Aggregator stage, running sequentially, that re-aggregates based on the DoNotCall flag.

Correct Answer: A,D

Question 2

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

A. You need to create a WSDL.

B. You do not need both input and output links in a single web service operation.

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: B,D

Question 3

What is the correct method to process a file containing multiple record types using the Complex Flat File stage?

A. Use a Filter stage to pre-process the input to the Complex Flat File stage.

B. Use a Modify stage to convert the output array from the Complex Flat File to a subrecord.

C. Manually break the file into multiple files by record type.

D. Define record ID constraints on the Records ID tab of the Complex Flat File stage.

Correct Answer: D

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

Correct Answer: A

Question 5

When defining a message handler, which three actions can be specified for a message?
(Choose three.)

A. Suppress from log.

B. Promote to "Warning".

C. Demote to "Warning".

D. Demote to "Informational".

E. Promote to "Fatal".

Correct Answer: A,B,D

Question 6

Which three lookup types may be performed in the Lookup stage? (Choose three.)

A. Range on the reject link

B. Equality match

C. Range on the reference link

D. Range on stream link

E. Negative match

Correct Answer: B,C,D

Question 7

Your job reads from a file using a Sequential File stage running sequentially. You are using a Transformer stage following the Sequential File stage to format the data in some of the columns. What is the default (Auto) partitioning method?

A. Round Robin

B. Hash

C. Random

D. Same

Correct Answer: A

Question 8

Which two steps are required to change from a normal lookup to a sparse lookup in an ODBC Enterprise stage? (Choose two.)

A. Establish a relationship between the key field column in the source stage with the database table field.

B. Sort the data on the reference link.

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

D. Change the lookup option in the stage properties to "Sparse".

Correct Answer: A,D

Question 9

Click the Exhibit button.
The CreateConfig Execute Command stage outputs a string to standard output. The string is space-delimited. The GenData Job Activity stage requires the third argument from the delimited string in one of its job parameters. How do you accomplish this?

A. Apply the String function to the $CommandOutput within the Activity Variable to retrieve the third argument.

B. Apply the Field function to the $CommandOutput within the Activity Variable to retrieve
the third argument.

C. Apply the Field function to the $ReturnValue within the Activity Variable to retrieve the third argument.

D. Apply the String function to the $ReturnValue within the Activity Variable to retrieve the third argument.

Correct Answer: B

Question 10

You have created a parallel job in which there are several stages that you want to be able to reuse in other jobs. You decided to create a parallel shared container from these stages. Identify two things that are true about this shared container. (Choose two.)

A. It can be used in sequencer jobs.

B. It can take advantage of Run Time Column Propagation (RCP).

C. It can be used in Transformer stage derivations.

D. It can have job parameters to resolve stage property values.

Correct Answer: B,D

Welcome to TestSimulate

IBM Websphere Datastage V.8.0 (000-418) Free Practice Test