InfoSphere DataStage v8.5 (000-421) Free Practice Test

Question 1

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 buffer operator uses both memory and disk storage.

C. In a clustered environment, using a disk space on an NFS mount for buffering improves performance.

D. The framework uses /tmp by default for buffering on Unix systems.

Correct Answer: B

Question 2

Which three of the following options does the dsjob command have? (Choose three.)

A. Specifying an appropriate log file

B. Setting an alias for a job

C. Stopping a job

D. Listing projects, jobs, stages, links, and parameters

Correct Answer: B,C,D

Question 3

You are using the Change Capture stage in your job design to identify changes made to the input link (before image) to obtain the results in the output link. This job will be using a multi-node configuration file when executed.
What are two requirements on the input link data for the Change Capture stage? (Select two)

A. Merged links

B. Sequential mode

C. Key partitioned

D. Sorted

Correct Answer: A,B

Question 4

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. Enable the job property "Record job performance data".

D. $APT_PM_PLAYER_TIMINGS

Correct Answer: B,D

Question 5

Which two job design techniques can be used to provide unique names to sequential output files that are used in multi-instance jobs? (Select two)

A. Prepend/append the Invocation ID to the file name.

B. Use parameters to identify file names.

C. Create the file name(s) from values contained in a value file.

D. Use the file name(s) from values contained in the data stream.

Correct Answer: A,B

Question 6

Where are project level message handlers defined?

A. Administrator Client

B. DSENV

C. Designer Client

D. Director Client

Correct Answer: A

Question 7

A customer is complaining of poor performance from the job shown in the exhibit, which aggregates and joins on ZIP code. Currently all partitioning is set to "Auto" and sort/partition insertion is allowed.

What would give the best performance improvement for the job?

A. Use same partitioning on all input links in the job; create the input data set by hash-partitioning its input on ZIP code.

B. Hash partition and sort on ZIP code prior to the Copy stage, and use same partitioning on the Aggregator and Join stages.

C. Hash partition and sort on ZIP code on the input links to the Aggregator and Join stages.

D. Hash partition and sort on ZIP code prior to the Copy stage and use entire partitioning on the output of the Aggregator stage.

Correct Answer: B

Question 8

What are two fundamental functions of the Information Server Source Code Integration based on the Eclipse Team framework? (Choose two.)

A. Commit Changes

B. Replace from Source Code Control Workspace

C. Send to Source Code Control Workspace

D. Rollback Changes

Correct Answer: B,C

Question 9

Which two statements are true for named node pools? (Select two)

A. Using appropriately named node pools force DataStage jobs to use named pipes between stages.

B. Using appropriately named node pools allow the separation of buffering from sorting disks.

C. Named node pools are required for DataStage jobs to scale across multiple machines on a grid or cluster.

D. Using appropriately named node pools is only available in clustered environments.

E. Using appropriately named node pool constraints limit stages to be executed only on the nodes defined in the node pools.

Correct Answer: B,E

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

Question 10

Which two statements are correct when using the Oracle Enterprise stage? (Choose two.)

A. DataStage Designer requires connectivity to the Oracle database during job development.

B. Define variable $TNS_ADMIN to point to the tnsnames.ora file location.

C. $APT_ORCHHOME/bin must appear before $ORACLE_HOME/bin in the $PATH.

D. Add $ORACLE_HOME/bin to the $PATH and $ORACLE_HOME/lib to the $LIBPATH, $LD_LIBRARY_PATH, or $SHLIB_PATH.

Correct Answer: C,D

Question 11

There is a requirement to load mainframe data with array columns having redefined fields into a flat file. How can the Complex Flat File

A. Within CFF, use the Complex File Load Option window with "Flatten all arrays" option selected. CFF will handle flattening automatically.

B. Select the Records ID tab on the Stage page. Select a record from the Records list. Select the column(s) with the redefine from the Column list. Within CFF, use the Complex File Load Option window with "Flatten selective arrays" option selected.

C. Within CFF, use the Complex File Load Option window with "Flatten selective arrays" option selected. Select the array with redefine column(s) and click redefine check box option.

D. CFF does not support flattening for redefined fields.

Correct Answer: B,C

Question 12

You are assigned to correct a job from another developer. The job contains 20 stages sourcing data from two Data Sets and many sequential files. The annotation in the job indicates who wrote the job and when, not the objective of the job. All link and stage names use the default names. One of the output columns has an incorrect value which should have been obtained using a lookup. What could the original developer have done to make this task easier for maintenance purposes?

A. Named all stages and links based on what they do.

B. Named all stage and links with column names and ideas.

C. Indicated all stage names within the job annotation.

D. Named all stage and links the same.

Correct Answer: A

Question 13

A customer requires reading a fixed-length sequential file in parallel where input rows can be identified. What two tasks must be done to meet these requirements? (Choose two.)

A. Ensure data has unique identifiers for data rows.

B. Specify Multiple readers per node.

C. Set partitioning method to Same.

D. Set $APT_READ_MULTI_NODES to TRUE.

Correct Answer: A,B

Question 14

A job reads from a sequential file using a SequentialFile stage with option "number of readers" set to 2. This data goes to a Transformer stage and then is written to a dataset using the DataSet stage. The default configuration file has three nodes. The environment variable $APT_DISABLE_COMBINATION is set to "True" and partitioning is set to "Auto". How many processes will be created?

A. 7

B. 5

C. 9

D. 12

Correct Answer: C

Question 15

Which three of the following are valid options for the dsjob command? (Choose three.)

A. Purging log files

B. Accessing log files

C. Setting an alias for a job

D. Stopping a job

E. Compiling a job

Correct Answer: B,C,D

Welcome to TestSimulate

IBM InfoSphere DataStage v8.5 (000-421) Free Practice Test