Assessment: InfoSphere DataStage v8.5 (A2090-421) Free Practice Test

Question 1

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. Use a sequencer to check transfer status and restart the job from the beginning on failure.

B. Create multiple readers to transfer file data and specify restartable mode on Input link tab.

C. Specify restartable mode on a transfer of the single file.

D. Manually split the file into multiple files and specify restartable mode on a transfer.

Correct Answer: D

Question 2

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

A. Entire partitioned

B. Sorted in ascending order

C. Key partitioned

D. Hash partitioned

E. Unsorted

Correct Answer: B,C

Question 3

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

Question 4

Which two statements about annotations are correct? (Select two)

A. The Short job description field will appears in job log when $APT_PM_SHOW_PIDS is set.

B. The Short job description field displays on log summary lines within Director client.

C. The Full job description field is only visible within the Designer Client.

D. An annotation can be drawn around one of more stages.

Correct Answer: A,D

Question 5

A job is using the Load method in the DB2 and Oracle Enterprise stage for parallel loading into a single table. The job fails at runtime and you see there are new table rows added. What would explain this result? (Select two)

A. Load operations are parallel.

B. Commit size is smaller than source data.

C. Some partitions completed before failure.

D. Load operations are sequential.

Correct Answer: A,B

Question 6

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. Insert Sort stage before the final Sequential File stage and use Round Robin collector for the Sequential File stage 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. Use SortMerge collector for the Sequential File input link.

Correct Answer: D

Question 7

You have a job that reads in Sequential File followed by a Transformer stage. When you run this job, which partitioning method will be used by default?

A. Round Robin

B. Hash

C. Random

D. Same

Correct Answer: A

Question 8

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. Setting the Preserve Partitioning flag to "Clear" will generate two instances of the Transformer stage.

C. Setting the Preserve Partitioning flag to "Set" will run one instance of the Transformer stage.

D. The DataStage job will abort.

E. Inserting a Sort stage prior to the Transformer stage will force its parallel execution.

Correct Answer: A,B

Question 9

A customer requires that a single output file generated by a parallel job be created in sort order. Which two job designs would achieve this goal? (Choose two.)

A. Set the "Execution Mode" in the Advanced stage properties tab of the parallel Sort stage to execute sequentially.

B. Write the result to a parallel dataset, then write a shell script to convert the dataset records to text format, in sorted order.

C. Use a parallel sort and partition the input to the SequentialFile stage using a Sort Merge collector.

D. Specify both partition and sort key columns on the input to the target SequentialFile stage.

E. Insert a sorted Funnel stage before the input to the output SequentialFile stage.

Correct Answer: A,C

Question 10

The Teradata Enterprise stage uses a distributed FastExport to access data. What is a limitation to distributed FastExport?

A. Multiple-AMP requests are allowed.

B. Aggregates and most arithmetic operators in the SELECT statement are allowed.

C. Non-data access (e.g., pseudo-tables like DATE or USER) is allowed.

D. The use of the USING modifier is allowed.

Correct Answer: A

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

Question 11

Which three actions can improve sort performance in a DataStage job? (Choose three.)

A. Adjust the "Restrict Memory Usage" option in the Sort stage.

B. Run the job sequentially so that only one sort process is invoked.

C. Use the stable-sort option to avoid the random ordering of non-key data.

D. Specify only the key columns which are necessary.

E. Minimize the number of sorts used within a job flow.

Correct Answer: A,D,E

Welcome to TestSimulate

IBM Assessment: InfoSphere DataStage v8.5 (A2090-421) Free Practice Test